Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formats being lost
I thought I'd posted this earlier but I can't find it!
We have a number of spreadsheets that seem to be losing their cell formats when they are saved. The user updates the files and saves to the Excel 2007 format. Everything appreas normal, but when the files are opened various cells lose their formatting. The users are fairly competant with Excel which would suggest it is not user error. It could be a coincidence, but I don't recall this being an issue before Office SP2 was rolled out. It's very random. The files in use have been around for years and worked consistantly until now. I'm stumped. I can't find musch about this on the net except an issue where the normal style has a date default number - something we have also found on thses files. My feeling is that perhaps the styles table is getting corrupted and Excel cannot apply a style, but that's me grasping at straws. Any help would be apprciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lost formats | Excel Discussion (Misc queries) | |||
Lost charts and conditional formats when connecting an LCD monitor | Excel Discussion (Misc queries) | |||
File Error. Some number formats may have been lost. | Excel Discussion (Misc queries) | |||
Chart Series Formats lost when list re -sorted | Excel Discussion (Misc queries) | |||
How do I keep a running total of pounds lost and percentage lost | Excel Discussion (Misc queries) |