Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting lost due to corruption
Hello,
Multiple Excel 2003 files from the accounting department (not the same person) end up losing formatting for no apparent reason. The file is working fine. User saves work then closes file. Upon next opening (minutes, days, weeks) there is a corruption error and the file loses all formatting. This doesn't happen to all of the files but it's happened to at least 3 different files several times each. One of the files I believe is the 4,000 combo formatting limit but the other two files are small and only have bold, some lines and some red text. Error upon opening: Errors were detected in €˜filename.xls but Microsoft Excel was able to open the file by making the repairs listed below. Save file to make these repairs permanent. --Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted. Relevant info: -Excel 2003 SP2 -Cells contain < 250 characters -Issue has occurred on at least 3 different computers with different files -No external links in the file - However when saving the file on my machine (Excel 2007) the compatibility message states: "some formulas in this workbook are linked to other workbooks that are closed" -No pivot tables -No hidden text or worksheets -Protection is off -Formatting doesn't exceed 4000 combinations -File size: 73 kb -5 worksheets in the workbook -No macros Troubleshooting: -Copy Paste Special Values only. Reformatted workbook taking care not to exceed the limit. -Unable to duplicate error on my computer -All over google, google groups, Microsoft and this web site trying to find someone with a similar issue. No luck :( -Visually inspected all formulas using (Ctrl ` to toggle) but nothing was linked to outside workbooks. Worksheets 2 - 5 contain one link to the first worksheet and appears to be working properly. Any help would be greatly appreciated. -- Thank you, Dawn |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting lost due to corruption
it happens some times
-File size: 73 kb maybe its better to re-make the small file. "Dawn" wrote: Hello, Multiple Excel 2003 files from the accounting department (not the same person) end up losing formatting for no apparent reason. The file is working fine. User saves work then closes file. Upon next opening (minutes, days, weeks) there is a corruption error and the file loses all formatting. This doesn't happen to all of the files but it's happened to at least 3 different files several times each. One of the files I believe is the 4,000 combo formatting limit but the other two files are small and only have bold, some lines and some red text. Error upon opening: Errors were detected in €˜filename.xls but Microsoft Excel was able to open the file by making the repairs listed below. Save file to make these repairs permanent. --Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted. Relevant info: -Excel 2003 SP2 -Cells contain < 250 characters -Issue has occurred on at least 3 different computers with different files -No external links in the file - However when saving the file on my machine (Excel 2007) the compatibility message states: "some formulas in this workbook are linked to other workbooks that are closed" -No pivot tables -No hidden text or worksheets -Protection is off -Formatting doesn't exceed 4000 combinations -File size: 73 kb -5 worksheets in the workbook -No macros Troubleshooting: -Copy Paste Special Values only. Reformatted workbook taking care not to exceed the limit. -Unable to duplicate error on my computer -All over google, google groups, Microsoft and this web site trying to find someone with a similar issue. No luck :( -Visually inspected all formulas using (Ctrl ` to toggle) but nothing was linked to outside workbooks. Worksheets 2 - 5 contain one link to the first worksheet and appears to be working properly. Any help would be greatly appreciated. -- Thank you, Dawn |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting lost due to corruption
Thanks for the reply. The file size may be small but there is a lot of text
in it and basic calculations. If the file only corrupted one time then I would agree but there's some underlying issue that is causing this file to become corrupted over and over again on different machines. This also has happened to two other workbooks that were much larger. Any other suggestions? -- "DumbLittleMan" wrote: it happens some times -File size: 73 kb maybe its better to re-make the small file. "Dawn" wrote: Hello, Multiple Excel 2003 files from the accounting department (not the same person) end up losing formatting for no apparent reason. The file is working fine. User saves work then closes file. Upon next opening (minutes, days, weeks) there is a corruption error and the file loses all formatting. This doesn't happen to all of the files but it's happened to at least 3 different files several times each. One of the files I believe is the 4,000 combo formatting limit but the other two files are small and only have bold, some lines and some red text. Error upon opening: Errors were detected in €˜filename.xls but Microsoft Excel was able to open the file by making the repairs listed below. Save file to make these repairs permanent. --Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted. Relevant info: -Excel 2003 SP2 -Cells contain < 250 characters -Issue has occurred on at least 3 different computers with different files -No external links in the file - However when saving the file on my machine (Excel 2007) the compatibility message states: "some formulas in this workbook are linked to other workbooks that are closed" -No pivot tables -No hidden text or worksheets -Protection is off -Formatting doesn't exceed 4000 combinations -File size: 73 kb -5 worksheets in the workbook -No macros Troubleshooting: -Copy Paste Special Values only. Reformatted workbook taking care not to exceed the limit. -Unable to duplicate error on my computer -All over google, google groups, Microsoft and this web site trying to find someone with a similar issue. No luck :( -Visually inspected all formulas using (Ctrl ` to toggle) but nothing was linked to outside workbooks. Worksheets 2 - 5 contain one link to the first worksheet and appears to be working properly. Any help would be greatly appreciated. -- Thank you, Dawn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List Formatting Lost | Excel Worksheet Functions | |||
Cell formatting changes lost | Excel Discussion (Misc queries) | |||
How do I fix . . remove formatting to avoid corruption . . | Excel Discussion (Misc queries) | |||
Lost Border Formatting | Excel Discussion (Misc queries) | |||
Lost formatting in Excel | Excel Discussion (Misc queries) |