Part Calculate a sheet ?

thakman

Board Regular
Joined
Jun 12, 2006
Messages
74
Hello

I have worksheet that has many formula’s in it when my macro is running it is taking a long time due to the recalculation, can anybody advise if I can stop excel calculating a range while leaving the first range on automatic calculation.

Eg Cells named primary_calc – I want these to be calculated all the time (automatic calculation) while the ranage called secondary_calc I want the calculation in this area to be completed only when I add code (ie at the end).

Alternatively can I move the fomula’s in the seconday_calc into a separate sheet and stop the sheet from being calculated when the inputs change, I do not really want to move all the secondary calc formula’s into a new workbook.


Thanks in advance
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
You could write a very basic macro to calculate certain cells or ranges, e.g.

Range("A6:A10").Calculate
 

thakman

Board Regular
Joined
Jun 12, 2006
Messages
74
Yes but the first range needs to be continuously recalculated, I would have to insert that code nearly every other line.
 

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
Then the only alternative is to move one set of formulae to a new sheet, and set that sheet to auto/manual at the start of your macro.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,318
Messages
5,600,925
Members
414,416
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top