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
"keepITcool" wrote in message
.com...
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 :
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" wrote in message
.com...
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 :
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...b;en-us;215783
Any known workarounds?
Thanks for any experience out there.
Alex J