View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JERM-H JERM-H is offline
external usenet poster
 
Posts: 1
Default Excel 2007 - font/cell formatting lost saving 2003 xls

Issue: cell/text formatting is automatically removed after I open a saved
document. This problem has occurred 3-4 different spreadsheets:

- After I upgraded to Office 2007, I was working on a basic spreadsheet
(just data columns with fonts, font colours, font highlights and sorted) that
I had previously saved using 2003 as a XLS. I was using/running
Compatibility mode and no compatibility issues where reported when I saved
the documents. After I added a few new lines, I saved the excel spreadsheet
as XLS and reopened the file, all of the cell formatting €“ font, colours,
where moved and I was left with a basic black text document in the excel 2007
default font and no colours or cell formatting.

Why does this keep occurring?