These are the latest Microsoft words describing how these limits are changed
in Excel 12 (from David Gainer's Excel12 Blog).
It is possible that you can avoid one or more of these limits by splitting
large worksheets into multiple smaller worksheets. I have not tried it so I
dont know.
The number of cells that may depend on a single area before Excel must do
full calculations instead of partial calculations (because it can no longer
track the dependencies required to do partial calculations)
Old Limit: 8k
New Limit: Limited by available memory
The number of different areas in a sheet that may have dependencies before
Excel must do full calculations instead of partial calculations (because it
can no longer track the dependencies required to do partial calculations)
Old Limit: 64k
New Limit: Limited by available memory
"neda5" <(E-Mail Removed)> wrote in message
news:6DA284E3-43CE-4D04-A12E-(E-Mail Removed)...
> Do you know if that limit is per sheet or for the entire workbook?
> If I were to split my biger sheets in a few worksheets, should that solve
> the problem?
> Thanks. Neda
>
> "Charles Williams" wrote:
>
>> The message does not go away until you close and reopen Excel.
>>
>> see http://www.decisionmodels.com/calcsecretsf.htm
>>
>> Charles
>> ______________________
>> Decision Models
>> FastExcel 2.2 Beta now available
>> www.DecisionModels.com
>>
>> "neda5" <(E-Mail Removed)> wrote in message
>> news:22A113D4-A497-4935-9CA4-(E-Mail Removed)...
>> > Thanks.
>> > However, I deleted most of the formulas to make sure that I don't have
>> > more
>> > than the limit of cell dependencies and it still gives me that message.
>> > Any other ideas?
>> > Thanks
>> >
>> > "Chip Pearson" wrote:
>> >
>> >> You will get this if there are more than 64K cell dependencies.
>> >> The workbook does calculate properly, but the message appears in
>> >> the status bar.
>> >>
>> >>
>> >> --
>> >> Cordially,
>> >> Chip Pearson
>> >> Microsoft MVP - Excel
>> >> Pearson Software Consulting, LLC
>> >> www.cpearson.com
>> >>
>> >>
>> >> "neda5" <(E-Mail Removed)> wrote in message
>> >> news:844C0152-B79F-4CCC-9E86-(E-Mail Removed)...
>> >> > Hi,
>> >> > I have a rather large spreadsheet (apx 30MB) and all of a
>> >> > sudden the
>> >> > calculate message kept reapearing in the status bar at the
>> >> > bottom. I am in
>> >> > manual mode so I hit F9 and it calculates to a certain level
>> >> > and then goes
>> >> > back to show calculate. I don't show having a circular and my
>> >> > itirations is
>> >> > off and I don't show any links to other documents. Since the
>> >> > file is rather
>> >> > large and I have a bunch of formulas linking all over the place
>> >> > I tried to
>> >> > erase my most formula heavy sheets and see what happens, but
>> >> > Calculate
>> >> > remains.
>> >> > I have read all the posts on the issue and nothing seems to
>> >> > help me.
>> >> > Any ideas????
>> >> > Thanks a bunch.
>> >> > Neda
>> >>
>> >>
>> >>
>>
>>
>>
Similar Threads
