Calculation

Tuberockin · Apr 9th, 2002, 02:47 AM

Hi guys,

Does anyone know how I can limit the calculation of a workbook to a single worksheet?

The problem is, I have quite a large workbook and only one part of one worksheet, which is a reference to time, changes each time the sheet is opened. Still it takes a good 45 seconds to finish the calculation, which becomes very frustrating.

No probs as far as speed or memory of computer goes. Both are more than sufficient.

Any suggestions?

Thankyou in advance

Tuberockin · Apr 9th, 2002, 02:55 AM

My apologies.

I just looked a few pages back and saw a very familiar question. Should have looked back first.

Sorry guys.

Dave Hawley · Apr 9th, 2002, 03:26 AM

Hi Tuberockin

You may or may not take my advise, but i advise strongly against putting any spreadsheet into manual calculation mode as it's thwart with potetioal errors!

Any spreasheet that requires being run in manual is most likely be designed incorrectly.

Consider replacing any array formuals (the worst culprit) with the Database function, and/or Pivot Tables. Restrict the use of any Custom Functions (UDF's). Restrict the range that any formulas reference to their needed range only. Dynamic named ranges are ideal for this: http://www.ozgrid.com/Excel/DynamicRanges.htm If you have many volatile funnctions (eg TODAY(), NOW() etc) consider placing them in one cell and referencing that cell as needed.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 02:47 AM	#1
Tuberockin New Member Join Date: Feb 2002 Location: Qld, Australia Posts: 12	Hi guys, Does anyone know how I can limit the calculation of a workbook to a single worksheet? The problem is, I have quite a large workbook and only one part of one worksheet, which is a reference to time, changes each time the sheet is opened. Still it takes a good 45 seconds to finish the calculation, which becomes very frustrating. No probs as far as speed or memory of computer goes. Both are more than sufficient. Any suggestions? Thankyou in advance

Apr 9th, 2002, 02:55 AM	#2
Tuberockin New Member Join Date: Feb 2002 Location: Qld, Australia Posts: 12	My apologies. I just looked a few pages back and saw a very familiar question. Should have looked back first. Sorry guys.

Apr 9th, 2002, 03:26 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Tuberockin You may or may not take my advise, but i advise strongly against putting any spreadsheet into manual calculation mode as it's thwart with potetioal errors! Any spreasheet that requires being run in manual is most likely be designed incorrectly. Consider replacing any array formuals (the worst culprit) with the Database function, and/or Pivot Tables. Restrict the use of any Custom Functions (UDF's). Restrict the range that any formulas reference to their needed range only. Dynamic named ranges are ideal for this: http://www.ozgrid.com/Excel/DynamicRanges.htm If you have many volatile funnctions (eg TODAY(), NOW() etc) consider placing them in one cell and referencing that cell as needed.