ERROR: "Unable to save data and formatting"
 

Hi,

I'm getting this error message more and more frequently now and it's getting
worrying. It happens when extending formulae and formatting in an existing
sheet to cover approx 540 rows.

Message reads:
"Excel could not save all the data and formatting you recently added to
[myFile}.xls
If you want to continue saving changes without repairing the problem, click
OK"

As far as I can see the only thing missing if it's saved 'with errors' is
that the conditional formatting has been removed from row 300 onwards.

Does anyone have any clue as to what may be causing this?

Thanks

Giz