Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File error some number formats may have been lost
The answer in 2003 is to unprotect any protected sheets, right click on a
cell and select Format Cells, then Custom and in the Custom Formats find Text and delete that then save changes. This worked for me so that when the file is opened in 2000 the error message is no longer displayed. -- with kind regards Spike "Spike" wrote: I have created a workbook (in Excel 2003) comprising 6 sheets with several macros behind it. After the macros have run it saves down a new workbook with no macros and just the raw data plus some formulas. If this workbook is opened in Excel 2000 it shows an error message "File Error. Some number formats may have been lost". I have searched the net etc and it seems quite a common problem but i cannot find the cause. If i add one new blank spreadsheet and delete all the others so the workbook contains no data whatsoever and only one new blank sheet so the only common thing is the filename it still shows the same error message which i find quite bizarre does anyone have any ideas?? -- with kind regards Spike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number formats lost | Excel Discussion (Misc queries) | |||
File Error. Some number formats may have been lost. | Excel Discussion (Misc queries) | |||
File Error: Data may have been lost. | Excel Discussion (Misc queries) | |||
File error. Some number formats may have been lost. | Excel Programming | |||
File Error: Data May Have Been Lost | Excel Discussion (Misc queries) |