Why does an Excel 2007 file lose its format when reopened?

B

Bob Umlas, Excel MVP

You may have too many cell formats/styles. To see if that's possibly true,
click on the Cell Styles "More" arrow and see if you have a gazillion styles
showing. If that's true, you can remove unused styles by saving the workbook
as a web page, closing, reopening, save as a normal workbook.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste to excel from word - auto format problem 1
Excel does not accept text format! 0
Auto match destination formatting for Mac 0
Visio 2019 not able to save as Autocad .dwg file 0
Merging from an Excel file with graphics 1
Excel 2007 objects paste linked into PowerPoint 2007, why doespowerPoint reopen the excel file for e 0
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Lose Changes to Style When Document ReOpened 25

Top