ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   recalc setting by range (https://www.excelbanter.com/excel-discussion-misc-queries/169697-recalc-setting-range.html)

Steve

recalc setting by range
 
Can you set up just one sheet in a workbook to recalc manually?

RagDyeR

recalc setting by range
 
To calculate *only* the active sheet (sheet you're in), and leave the rest
of the WB unchanged, use:

<Shift <F9

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Steve" wrote in message
...
Can you set up just one sheet in a workbook to recalc manually?




All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com