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.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Excel is continually trying to figure out what type of data is being stored in a cell. If it can interpret a value as a ...Discover More
Applying different formatting to the text within a cell can seem a bit confusing. This is certainly the case when it ...Discover More
Information in a worksheet needs to be displayed using fonts. If you understand the two different types of fonts ...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.