ExcelBanter - Sheets lose formats

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sheets lose formats (https://www.excelbanter.com/excel-discussion-misc-queries/249676-sheets-lose-formats.html)

Mike H.

Sheets lose formats

I have a file that I created by upgrading from Excel 2003. In 2007 the file
saves fine. I had a user complain he didn't have Excel 2007 so I saved as a
..xls file and now everytime I reopen the file all my formating on every sheet
is gone. If I reapply the formatting and then save as a .xlsm file, all the
formatting stays in the file. Ideas?

All times are GMT +1. The time now is 10:13 AM.