Excel not saving all data and formatting

G

Guest

Unable to save any further data or formatting to workbook. Each time I try to
save I get the following message:

Excel could not save all the data and formatting you recently added

To return to your workbook without saving click Cancel
If you want to continue saving changes without repairing the problem, click
OK.

When I click on help there is no message
 
D

Dave Peterson

Maybe:

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=213904

And if you ever have trouble opening this file, you may want to try openOffice.

http://www.openoffice.org, a 60-65 meg download or a CD

A few people have posted that they could open the file in OpenOffice, then
remove some of the formatting, save it and then excel would open that file ok.

===========
You may want to search google for that phrase:

http://groups.google.co.uk/group/mi..."+group:*excel*&rnum=7&hl=en#fec3bd5c693d7c35

or

http://snipurl.com/hi1c

There are a few hits that point at conditional formatting and data|validation
being the sometimes cause.
 

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

Top