Excel could not save all of your data and formats

[Alex J]

All,
Microsoft KB article 215783 identifies that this message is issued by excel
on a save command when 2050 rows have conditional formatting. This is listed
as a limitation of how excel saves information.

http://support.microsoft.com/default.aspx?scid=kb;en-us;215783

Any known workarounds?

Thanks for any experience out there.
Alex J

 

[keepITcool]

A very short KB article with very few details..
you MAY receive an error message...


I tried to replicate it in xlXP (also listed as problematic)

However I can format an enormous amount of cells
(5000 rows columns A thru IU) with conditional formatting. AND save it
AND read it. I also formatted some columns.


However that conditional formatting was all similar and fairly simple,
(no complex formulas).

so you may do some test to establish if it is the formatcondition
in itself that gives the problem, or the complexity of formulas used in
the conditions...


It may also have to do with the number of areas of formatting.
if the NUMBER of different areas is small (so you have large block of
similar formats) then I expect fewer problems. (goto special:Same
Cond.Formatting)



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Alex J wrote :

 

[Alex J]

Thanks for the feedback, kITc.
You are correct - the conditions are similar, and not especially complex,
but spread across many columns. Sigh - thanks Bill!

Do you think that entering conditional format using array formulas will be
more efficient that "cell at a time"?

Alex J

 

[keepITcool]

I've build huge sheets .. with a hidden column containing the
validation
and or formatting formulas.
the ConditionalFormats formula just checks if columnX is true/false

when the formulas are working I often place them in a Name object.
it may be a bit slower, but it saves lots of space if the formulas are
long.

using array formulas (not 'in-cell' array) in that column will make
inserting rows very tricky.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Alex J wrote :

 

[Alex J]

Thanks for the futher input. I have (at least tempoarily) resolved the
problem by reducing the number of conditions on the Conditional Format
columns.

Regards,
APJ