REPOST as ISP's NNTP server just back up after crash.

Hello

I have 3 workbooks linked together in this order
2 linked to lookup 1 database workbook of 1 worksheet
then 1 of the 2 others linked to the other. These 2 have multiple
worksheets with lots of formulae in each for comparing price results
at Tender and Completion of a large Construction Project to prepare a
line by line Claim for Extras for Variations.

My problem is, that when I load the last big workbook, "Calculate"
appears in the Status bar at the bottom of all sheets in all open
workbooks, even though Calculation is set to Auto. To allow me to keep
working, I have to set Calculation to Manual with provision to
calculate each workbook prior to Saving. (this wastes a lot of time
and is fraught with lurking disasters...I've had a few Excel crashes)

Using Office 2000 Excel on Win 98SE (locally) on a Pentium 500 with
256mB Ram, floating Swapfile and all the files are on our office LAN
Server.

Is there some limit to what Excel can do before it chokes down or
should I be looking for some other glitch in the setup of the
workbooks?

Does ANYONE know? (I previously got one reply "Maybe".)

Or am I in the wrong Group?


-- Reader to complete...
-- Please reply to this ng as my email adress is fake:

-- Regards

-- CC

http://www.decisionmodels.com/calcsecretsf.htm

--
Kind regards,

Niek Otten

"Clarence Crow" wrote in message
...
REPOST as ISP's NNTP server just back up after crash.

Hello

I have 3 workbooks linked together in this order
2 linked to lookup 1 database workbook of 1 worksheet
then 1 of the 2 others linked to the other. These 2 have multiple
worksheets with lots of formulae in each for comparing price results
at Tender and Completion of a large Construction Project to prepare a
line by line Claim for Extras for Variations.

My problem is, that when I load the last big workbook, "Calculate"
appears in the Status bar at the bottom of all sheets in all open
workbooks, even though Calculation is set to Auto. To allow me to keep
working, I have to set Calculation to Manual with provision to
calculate each workbook prior to Saving. (this wastes a lot of time
and is fraught with lurking disasters...I've had a few Excel crashes)

Using Office 2000 Excel on Win 98SE (locally) on a Pentium 500 with
256mB Ram, floating Swapfile and all the files are on our office LAN
Server.

Is there some limit to what Excel can do before it chokes down or
should I be looking for some other glitch in the setup of the
workbooks?

Does ANYONE know? (I previously got one reply "Maybe".)

Or am I in the wrong Group?


-- Reader to complete...
-- Please reply to this ng as my email adress is fake:

-- Regards

-- CC

maybe..

http://support.microsoft.com/default.aspx?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References

Clarence Crow wrote:

REPOST as ISP's NNTP server just back up after crash.

Hello

I have 3 workbooks linked together in this order
2 linked to lookup 1 database workbook of 1 worksheet
then 1 of the 2 others linked to the other. These 2 have multiple
worksheets with lots of formulae in each for comparing price results
at Tender and Completion of a large Construction Project to prepare a
line by line Claim for Extras for Variations.

My problem is, that when I load the last big workbook, "Calculate"
appears in the Status bar at the bottom of all sheets in all open
workbooks, even though Calculation is set to Auto. To allow me to keep
working, I have to set Calculation to Manual with provision to
calculate each workbook prior to Saving. (this wastes a lot of time
and is fraught with lurking disasters...I've had a few Excel crashes)

Using Office 2000 Excel on Win 98SE (locally) on a Pentium 500 with
256mB Ram, floating Swapfile and all the files are on our office LAN
Server.

Is there some limit to what Excel can do before it chokes down or
should I be looking for some other glitch in the setup of the
workbooks?

Does ANYONE know? (I previously got one reply "Maybe".)

Or am I in the wrong Group?

-- Reader to complete...
-- Please reply to this ng as my email adress is fake:

-- Regards

-- CC

--

Dave Peterson

On Fri, 2 Dec 2005 18:37:53 +0100, "Niek Otten"
wrote:

http://www.decisionmodels.com/calcsecretsf.htm

Thanks....I'll try to get my head around this.

Maybe we should learn Access to do this work, but it's hard to accept
change even when the work volume has increased to an almost
unmanageable limit with Excel.


-- Reader to complete...
-- Please reply to this ng as my email adress is fake:

-- Regards

-- CC