Software

Ask something
Discussion Locked

Too many different cell formats in Excel

0 helpful
2 replies

by moncher

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Excel workbook that is giving me the error "too many different cell formats" when I try to open it. I found information about this in the MS knowledge base, and their solution is to remove some of the formatting, but I can't open it to dothat. I know that I can open it in Word to see the information, but I would rather try to get it open again in Excel. Any ideas?

2 replies

by brian

Try changing the file extension to .csv Hopefully it will then open. If it doesn't have an Excel looking icon (once you change it to csv) then you need to open Excel to a blank Workbook and then select from the menu file/open and change the file type in the drop down menu to text files or all file types. locate the CSV file and it should open.

by moncher

Thanks for the suggestion however I am still unable to open the file. I get the same error message with the .csv extension

This discussion is closed to new replies.