Excel cannot save formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a spreadsheet that has a fair bit of conditional formatting in it,
but maybe not the most I have ever used. After updating and then saving the
file I get a message "Excel could not save all the data & formatting you
recently added to xyz.xls". I have the option to continue to save without
all the formatting applied or to cancel. The Help button gives me an empty
window. The file itself is only 700KB.
Can anyone advise me on this one?

thanks
 
It sounds like it's time to remove some of the formatting.

I've found that if I format complete columns all at once, excel doesn't see it
as 65536 different formats.

Maybe you can do something like that.
 

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

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel 2003 save as .XLSX 10
Excell 2021 0
Cannot save formatting 3
Excel And Notepad 3
Losing Conditional Formatting after Save 5
lines of conditional format 1
Saving in new file format 2

Back
Top