software

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

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.comquot;neda5quot; gt; wrote in message
...
gt; Hi,
gt; I have a rather large spreadsheet (apx 30MB) and all of a
gt; sudden the
gt; calculate message kept reapearing in the status bar at the
gt; bottom. I am in
gt; manual mode so I hit F9 and it calculates to a certain level
gt; and then goes
gt; back to show calculate. I don't show having a circular and my
gt; itirations is
gt; off and I don't show any links to other documents. Since the
gt; file is rather
gt; large and I have a bunch of formulas linking all over the place
gt; I tried to
gt; erase my most formula heavy sheets and see what happens, but
gt; Calculate
gt; remains.
gt; I have read all the posts on the issue and nothing seems to
gt; help me.
gt; Any ideas????
gt; Thanks a bunch.
gt; Neda
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

quot;Chip Pearsonquot; wrote:

gt; You will get this if there are more than 64K cell dependencies.
gt; The workbook does calculate properly, but the message appears in
gt; the status bar.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;neda5quot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; I have a rather large spreadsheet (apx 30MB) and all of a
gt; gt; sudden the
gt; gt; calculate message kept reapearing in the status bar at the
gt; gt; bottom. I am in
gt; gt; manual mode so I hit F9 and it calculates to a certain level
gt; gt; and then goes
gt; gt; back to show calculate. I don't show having a circular and my
gt; gt; itirations is
gt; gt; off and I don't show any links to other documents. Since the
gt; gt; file is rather
gt; gt; large and I have a bunch of formulas linking all over the place
gt; gt; I tried to
gt; gt; erase my most formula heavy sheets and see what happens, but
gt; gt; Calculate
gt; gt; remains.
gt; gt; I have read all the posts on the issue and nothing seems to
gt; gt; help me.
gt; gt; Any ideas????
gt; gt; Thanks a bunch.
gt; gt; Neda
gt;
gt;
gt;

The message does not go away until you close and reopen Excel.

see www.decisionmodels.com/calcsecretsf.htm

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

quot;neda5quot; gt; wrote in message
...
gt; Thanks.
gt; However, I deleted most of the formulas to make sure that I don't have
gt; more
gt; than the limit of cell dependencies and it still gives me that message.
gt; Any other ideas?
gt; Thanks
gt;
gt; quot;Chip Pearsonquot; wrote:
gt;
gt;gt; You will get this if there are more than 64K cell dependencies.
gt;gt; The workbook does calculate properly, but the message appears in
gt;gt; the status bar.
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Cordially,
gt;gt; Chip Pearson
gt;gt; Microsoft MVP - Excel
gt;gt; Pearson Software Consulting, LLC
gt;gt; www.cpearson.com
gt;gt;
gt;gt;
gt;gt; quot;neda5quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt; I have a rather large spreadsheet (apx 30MB) and all of a
gt;gt; gt; sudden the
gt;gt; gt; calculate message kept reapearing in the status bar at the
gt;gt; gt; bottom. I am in
gt;gt; gt; manual mode so I hit F9 and it calculates to a certain level
gt;gt; gt; and then goes
gt;gt; gt; back to show calculate. I don't show having a circular and my
gt;gt; gt; itirations is
gt;gt; gt; off and I don't show any links to other documents. Since the
gt;gt; gt; file is rather
gt;gt; gt; large and I have a bunch of formulas linking all over the place
gt;gt; gt; I tried to
gt;gt; gt; erase my most formula heavy sheets and see what happens, but
gt;gt; gt; Calculate
gt;gt; gt; remains.
gt;gt; gt; I have read all the posts on the issue and nothing seems to
gt;gt; gt; help me.
gt;gt; gt; Any ideas????
gt;gt; gt; Thanks a bunch.
gt;gt; gt; Neda
gt;gt;
gt;gt;
gt;gt;
Thanks. That worked.

quot;Charles Williamsquot; wrote:

gt; The message does not go away until you close and reopen Excel.
gt;
gt; see www.decisionmodels.com/calcsecretsf.htm
gt;
gt; Charles
gt; ______________________
gt; Decision Models
gt; FastExcel 2.2 Beta now available
gt; www.DecisionModels.com
gt;
gt; quot;neda5quot; gt; wrote in message
gt; ...
gt; gt; Thanks.
gt; gt; However, I deleted most of the formulas to make sure that I don't have
gt; gt; more
gt; gt; than the limit of cell dependencies and it still gives me that message.
gt; gt; Any other ideas?
gt; gt; Thanks
gt; gt;
gt; gt; quot;Chip Pearsonquot; wrote:
gt; gt;
gt; gt;gt; You will get this if there are more than 64K cell dependencies.
gt; gt;gt; The workbook does calculate properly, but the message appears in
gt; gt;gt; the status bar.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Cordially,
gt; gt;gt; Chip Pearson
gt; gt;gt; Microsoft MVP - Excel
gt; gt;gt; Pearson Software Consulting, LLC
gt; gt;gt; www.cpearson.com
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;neda5quot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi,
gt; gt;gt; gt; I have a rather large spreadsheet (apx 30MB) and all of a
gt; gt;gt; gt; sudden the
gt; gt;gt; gt; calculate message kept reapearing in the status bar at the
gt; gt;gt; gt; bottom. I am in
gt; gt;gt; gt; manual mode so I hit F9 and it calculates to a certain level
gt; gt;gt; gt; and then goes
gt; gt;gt; gt; back to show calculate. I don't show having a circular and my
gt; gt;gt; gt; itirations is
gt; gt;gt; gt; off and I don't show any links to other documents. Since the
gt; gt;gt; gt; file is rather
gt; gt;gt; gt; large and I have a bunch of formulas linking all over the place
gt; gt;gt; gt; I tried to
gt; gt;gt; gt; erase my most formula heavy sheets and see what happens, but
gt; gt;gt; gt; Calculate
gt; gt;gt; gt; remains.
gt; gt;gt; gt; I have read all the posts on the issue and nothing seems to
gt; gt;gt; gt; help me.
gt; gt;gt; gt; Any ideas????
gt; gt;gt; gt; Thanks a bunch.
gt; gt;gt; gt; Neda
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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

quot;Charles Williamsquot; wrote:

gt; The message does not go away until you close and reopen Excel.
gt;
gt; see www.decisionmodels.com/calcsecretsf.htm
gt;
gt; Charles
gt; ______________________
gt; Decision Models
gt; FastExcel 2.2 Beta now available
gt; www.DecisionModels.com
gt;
gt; quot;neda5quot; gt; wrote in message
gt; ...
gt; gt; Thanks.
gt; gt; However, I deleted most of the formulas to make sure that I don't have
gt; gt; more
gt; gt; than the limit of cell dependencies and it still gives me that message.
gt; gt; Any other ideas?
gt; gt; Thanks
gt; gt;
gt; gt; quot;Chip Pearsonquot; wrote:
gt; gt;
gt; gt;gt; You will get this if there are more than 64K cell dependencies.
gt; gt;gt; The workbook does calculate properly, but the message appears in
gt; gt;gt; the status bar.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Cordially,
gt; gt;gt; Chip Pearson
gt; gt;gt; Microsoft MVP - Excel
gt; gt;gt; Pearson Software Consulting, LLC
gt; gt;gt; www.cpearson.com
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;neda5quot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi,
gt; gt;gt; gt; I have a rather large spreadsheet (apx 30MB) and all of a
gt; gt;gt; gt; sudden the
gt; gt;gt; gt; calculate message kept reapearing in the status bar at the
gt; gt;gt; gt; bottom. I am in
gt; gt;gt; gt; manual mode so I hit F9 and it calculates to a certain level
gt; gt;gt; gt; and then goes
gt; gt;gt; gt; back to show calculate. I don't show having a circular and my
gt; gt;gt; gt; itirations is
gt; gt;gt; gt; off and I don't show any links to other documents. Since the
gt; gt;gt; gt; file is rather
gt; gt;gt; gt; large and I have a bunch of formulas linking all over the place
gt; gt;gt; gt; I tried to
gt; gt;gt; gt; erase my most formula heavy sheets and see what happens, but
gt; gt;gt; gt; Calculate
gt; gt;gt; gt; remains.
gt; gt;gt; gt; I have read all the posts on the issue and nothing seems to
gt; gt;gt; gt; help me.
gt; gt;gt; gt; Any ideas????
gt; gt;gt; gt; Thanks a bunch.
gt; gt;gt; gt; Neda
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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

quot;neda5quot; gt; wrote in message
...
gt; Do you know if that limit is per sheet or for the entire workbook?
gt; If I were to split my biger sheets in a few worksheets, should that solve
gt; the problem?
gt; Thanks. Neda
gt;
gt; quot;Charles Williamsquot; wrote:
gt;
gt;gt; The message does not go away until you close and reopen Excel.
gt;gt;
gt;gt; see www.decisionmodels.com/calcsecretsf.htm
gt;gt;
gt;gt; Charles
gt;gt; ______________________
gt;gt; Decision Models
gt;gt; FastExcel 2.2 Beta now available
gt;gt; www.DecisionModels.com
gt;gt;
gt;gt; quot;neda5quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Thanks.
gt;gt; gt; However, I deleted most of the formulas to make sure that I don't have
gt;gt; gt; more
gt;gt; gt; than the limit of cell dependencies and it still gives me that message.
gt;gt; gt; Any other ideas?
gt;gt; gt; Thanks
gt;gt; gt;
gt;gt; gt; quot;Chip Pearsonquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; You will get this if there are more than 64K cell dependencies.
gt;gt; gt;gt; The workbook does calculate properly, but the message appears in
gt;gt; gt;gt; the status bar.
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Cordially,
gt;gt; gt;gt; Chip Pearson
gt;gt; gt;gt; Microsoft MVP - Excel
gt;gt; gt;gt; Pearson Software Consulting, LLC
gt;gt; gt;gt; www.cpearson.com
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;neda5quot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Hi,
gt;gt; gt;gt; gt; I have a rather large spreadsheet (apx 30MB) and all of a
gt;gt; gt;gt; gt; sudden the
gt;gt; gt;gt; gt; calculate message kept reapearing in the status bar at the
gt;gt; gt;gt; gt; bottom. I am in
gt;gt; gt;gt; gt; manual mode so I hit F9 and it calculates to a certain level
gt;gt; gt;gt; gt; and then goes
gt;gt; gt;gt; gt; back to show calculate. I don't show having a circular and my
gt;gt; gt;gt; gt; itirations is
gt;gt; gt;gt; gt; off and I don't show any links to other documents. Since the
gt;gt; gt;gt; gt; file is rather
gt;gt; gt;gt; gt; large and I have a bunch of formulas linking all over the place
gt;gt; gt;gt; gt; I tried to
gt;gt; gt;gt; gt; erase my most formula heavy sheets and see what happens, but
gt;gt; gt;gt; gt; Calculate
gt;gt; gt;gt; gt; remains.
gt;gt; gt;gt; gt; I have read all the posts on the issue and nothing seems to
gt;gt; gt;gt; gt; help me.
gt;gt; gt;gt; gt; Any ideas????
gt;gt; gt;gt; gt; Thanks a bunch.
gt;gt; gt;gt; gt; Neda
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Thanks. I am still struggling to solve that issue in Excel 2003. What really
puzzled me is that I have much larger files with tons of formulas and I never
hit this issue before. I split the most formula heavy sheets, but it didn't
seem to help. I am really at a loss. Excel 2007 seems to deal with that
problem but until then...

quot;Charles Williamsquot; wrote:

gt; These are the latest Microsoft words describing how these limits are changed
gt; in Excel 12 (from David Gainer's Excel12 Blog).
gt;
gt; It is possible that you can avoid one or more of these limits by splitting
gt; large worksheets into multiple smaller worksheets. I have not tried it so I
gt; dont know.
gt;
gt; The number of cells that may depend on a single area before Excel must do
gt; full calculations instead of partial calculations (because it can no longer
gt; track the dependencies required to do partial calculations)
gt; Old Limit: 8k
gt; New Limit: Limited by available memory
gt;
gt; The number of different areas in a sheet that may have dependencies before
gt; Excel must do full calculations instead of partial calculations (because it
gt; can no longer track the dependencies required to do partial calculations)
gt; Old Limit: 64k
gt; New Limit: Limited by available memory
gt;

gt;