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.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
Want a quick way to add some underlines to your cell values? It's easy using the shortcuts provided in this tip.Discover More
Moving your custom formats into a formatting category other than "custom" isn't something you can do in Excel. Here's ...Discover More
Word provides a much wider range of formatting tools and options than you can find in Excel. One example is when it comes ...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.