Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 09-07-2005, 02:01 AM
Posts: n/a
Default Excel not saving all data and formatting

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

When I click on help there is no message
Reply With Quote
Old 11-16-2005, 04:07 PM
crocstar crocstar is offline
Join Date: Nov 2005
Posts: 1

Did you resolve the issue?

I'm having the same problem. I've searched the web and the closest I've got to a solution is that conditional formatting must be limited to 2050 rows. This doesn't seem to adequately answer the issue as I have other spreadsheets with a lot more conditional formatting rows that 2050.

I found that it is saves ok if I save the file as an earlier version of Excel. Not sure why this seems to work.
Reply With Quote
Old 04-09-2009, 12:51 PM
harshalsheth harshalsheth is offline
Join Date: Apr 2009
Posts: 1
harshalsheth is on a distinguished road

First create a Blank document in 97-2003 format. Then copy the sheet in 2007 format and paste it in the document created in 97 - 2003 format.

This will now retain the formating
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving Just one page.... derr04 Word 1 09-21-2007 10:46 AM
Automatically entering/fill data in cells in Excel 2003 dipdog Excel 0 08-17-2006 08:37 AM
Saving only "DATA" on excel? No white bottom? Excel 0 08-07-2006 09:27 AM
Saving file attachments Chief96 Outlook 0 12-01-2005 11:28 AM
Excel not saving all data and formatting Refreshing Data in Excel jamal420 Office 3 06-13-2005 03:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:44 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd. is not affiliated with Microsoft