Recalc questions

Mr930

Well-known Member
Joined
Aug 31, 2006
Messages
583
Is there a way to recalc portions of a spreadsheet? For instance, I have a multi tab spreadsheet, and one tab takes a very long time to recalc, but other tabs have simple, unrelated calculations. Sometimes I would like to recalc the simple tabs without waiting on the long recalc time of the complicated tab, is this possible?

Also, I have some sheets that do all of their calculations in VBA, called from cells. If I hit F9, those cells are not recalced unless one of the input cells has changed. Some times I have changed the VBA code but not the data, is there a way to force a recalc without changing any of the cells?

thanks
Fred
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,871
Hi Fred

Check the keyboard shortcuts

F9 - Calculate all sheets in all open workbooks
CTRL+ALT+F9 - Calculate all sheets in the active workbook
SHIFT+F9 - Calculate the active worksheet

Hope this helps
PGC
 

Watch MrExcel Video

Forum statistics

Threads
1,114,380
Messages
5,547,599
Members
410,802
Latest member
DataMgmtAnalyst7
Top