Hi Minitman,

See:

See MSKB article # 215783

'XL: "Excel Could Not Save All the Data and Formatting" Error Message'
http://support.microsoft.com/default...b;en-us;215783


---
Regards,
Norman



"Minitman" wrote in message
...
Greetings,

I have a sheet with a lot of links, formulas, formats and Conditional
Formats. I recently had to change the formulas to account for an
added column on a linked sheet. The formulas converted nicely but the
conditional formatting didn't fare so well. As I tried to correct the
problem, I soon found out that I could not save the corrects. I kept
getting a Microsoft Excel error message:

Excel could not save all the data and formatting you recently added to
1998-03.xls.

I tried to Detect and Repair under the Help menu, but it still won't
save the changes. I've closed everything down and rebooted, but that
didn't help either.

I don't know what else to do.

Anyone have any ideas?

TIA

-Minitman