Forum Home
Press F1
 
Thread ID: 75643 2007-01-06 00:28:00 Excel File Error bk T (215) Press F1
Post ID Timestamp Content User
513101 2007-01-06 00:28:00 Just encountered an Excel error:

When I open an file (downloaded) with my Excel 2003 an error message pops up saying "File error: data may have been lost" . I have to click OK many times before it finally opens the file. No problem in openning other files, however.

Copied the 'problem' file to another computer and it opens fine. Both manchines are running Office 2003.

Can someone help? 		bk T (215)
513102 2007-01-06 02:44:00 . softartisans . com/kbview_238 . aspxTitle" target="_blank">support . softartisans . com
Error: "Data may have been lost" when stripping macros with template object

Problem
When calling the Process method of the ExcelTemplate object, it is possible to strip macros from the template . xls or . xlt file . The third parameter of the process method, ExcludeMacro, is set to False by default . If set to True, macros in the template will be excluded from the generated spreadsheet .

Example:
objTemplate . Process "c:\folder\file . xls", saProcessOpenInPlace, True

If your original template . xls or . xlt file contains buttons which are associated with the macros which are being removed, Microsoft Excel will report a "data may have been lost" error when the newly generated spreadsheet is read . In fact, no data is actually lost . All original spreadsheet values, formulas, etc . will still be intact . Microsoft Excel reports this error because the buttons have been orphaned .



Which may not be the problem but I'd say there is a difference between the 2 Excels on your 2 PCs . One was probably installed without certain additional components which these files are trying to use . 		pctek (84)
513103 2007-01-06 04:24:00 support.softartisans.com
Error: "Data may have been lost" when stripping macros with template object

Problem
When calling the Process method of the ExcelTemplate object, it is possible to strip macros from the template .xls or .xlt file. The third parameter of the process method, ExcludeMacro, is set to False by default. If set to True, macros in the template will be excluded from the generated spreadsheet.

Example:
objTemplate.Process "c:\folder\file.xls", saProcessOpenInPlace, True

If your original template .xls or .xlt file contains buttons which are associated with the macros which are being removed, Microsoft Excel will report a "data may have been lost" error when the newly generated spreadsheet is read. In fact, no data is actually lost. All original spreadsheet values, formulas, etc. will still be intact. Microsoft Excel reports this error because the buttons have been orphaned.



Which may not be the problem but I'd say there is a difference between the 2 Excels on your 2 PCs. One was probably installed without certain additional components which these files are trying to use.

It used to be able to open (I download files from this site frequently) those files without any problem. But, now I've problems in opening even those files which I downloaded and saved in my PC. The explanations above seems very 'technical'. If I understand it correctly, it has something to do with the Macro security settings in my Excel.

I don't quite understand what does it mean by 'those buttons have been orphaned' I would be very grateful if someone could help me to overcome this issue.

Thanks 		bk T (215)
513104 2007-01-06 10:08:00 Any Excel gurus out there can solve this problem??? bk T (215)
513105 2007-01-06 11:17:00 I'm thinking, if I were to uninstall Excel and re-install it, will I solve the problem? :help:

Is it possible just to uninstall Excel alone? I don't want to disrupt all my personal configuration made for the other components of Office, especially Outlook.

Cheers 		bk T (215)
513106 2007-01-06 19:23:00 Yes, when you uninstall it will ask for the CD, you can Add/Remove Components of Office.

Take out Excel then add it back.
When you add it back makes ure you add in all the "extra" components with it. 		pctek (84)
513107 2007-01-06 21:15:00 Yes, when you uninstall it will ask for the CD, you can Add/Remove Components of Office.

Take out Excel then add it back.
When you add it back makes ure you add in all the "extra" components with it.

You should be able to use the repair function, which should be easier. 		Dannz (1668)
513108 2007-01-07 08:59:00 Just uninstalled and re-installed Excel. Unfortunately, still can't open the file.

:badpc::badpc::badpc:

What shall I do next ??? 		bk T (215)
513109 2007-01-07 12:06:00 bk T: It would appear that they've got macros running when you open these files. Download the files and hold the shift key while you double-click them to keep the macros from running. OR perhaps you used to have your macro security set NOT to run macros and now you have it set to run them. Check it out. :)


By the way...set the security the same as the "other PC" that doesn't experience the problem.

And "proper" Excel troubleshooting can be found here:
www.officearticles.com 		Dreamboat (9170)
513110 2007-01-07 21:08:00 bk T: It would appear that they've got macros running when you open these files. Download the files and hold the shift key while you double-click them to keep the macros from running. OR perhaps you used to have your macro security set NOT to run macros and now you have it set to run them. Check it out. :)


By the way...set the security the same as the "other PC" that doesn't experience the problem.

And "proper" Excel troubleshooting can be found here:
www.officearticles.com


The Macro Serurity setting is the same as my other computer - just checked. It must be some settings somewhere in Excel (or Office or even Windows) that is causing this annoyance. 		bk T (215)
1