Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel could not save all of your data and formats
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel could not save all of your data and formats
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel could not save all of your data and formats
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel could not save all of your data and formats
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel could not save all of your data and formats
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to save files in the formats of *.csv(MS-DOS) in Excel 2003 | Excel Discussion (Misc queries) | |||
how do i save chart formats as default | Charts and Charting in Excel | |||
Can I save formats like hidden columns... | New Users to Excel | |||
Save As Other Formats | Setting up and Configuration of Excel | |||
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) |