by Allen Wyatt
(last updated December 18, 2014)
Jennifer is in an office with ten people, all using Excel 2007. Several of them have intermittent problems with losing formatting. The formatting includes fonts, colors, shading, borders, number formats, and so on. They save and close the workbook; the next time they open it, the formatting is gone. They can't find a pattern, and were wondering if this is a known problem.
There is no acknowledgement from Microsoft that it is a known problem (at least, as far as we can find), but it apparently is a problem shared by many people. As far as we can tell, the problem could be due to two different potential causes.
First, you should make sure that your workbook is being saved in native Excel 2007/2010 format. If you are saving it in the older Excel 97-2003 format, then it is possible that the losses you are seeing are due to the formatting not being supported in the older format. This is particularly true with colors and conditional formatting.
The other possible cause is that the workbook file is corrupted in some manner. The solution is to transfer your data from the current workbook to a new workbook and then see if the problem occurs in the new one.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9484) applies to Microsoft Excel 2007 and 2010.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Excel allows you to adjust spacing between cell walls and the contents of those cells. It does not, however, allow you to ...Discover More
Currency is formatted differently in different corners of the world. Most formatting uses periods and commas to indicate ...Discover More
Have you ever entered information in a cell only for it to appear as hash marks? This tip explains why this happens, how ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.