Manual calculation setting
With calculation set to Manual, occasionally I would like a workbook that
takes a while to recalculate the whole workbook, just to recalculate the range I am currently working on. My workround at the moment is to highlight the range and then cycle through each cell in the range by pressing edit formula, F2 and then Enter. This is time consuming and noisy when trying to cycle through the range quickly. This 'problem' is not specific to one workbook as I have one workbook for each month of the year. Is there a quicker method? |
Manual calculation setting
Maybe you can isolate the range on one sheet and use SHIFT-F9 (Calculate Sheet)
For lots of information about calculation, visit Charles William's site: www.decisionmodels.com -- Kind regards, Niek Otten Microsoft MVP - Excel "skewey" wrote in message ... | With calculation set to Manual, occasionally I would like a workbook that | takes a while to recalculate the whole workbook, just to recalculate the | range I am currently working on. My workround at the moment is to highlight | the range and then cycle through each cell in the range by pressing edit | formula, F2 and then Enter. This is time consuming and noisy when trying to | cycle through the range quickly. This 'problem' is not specific to one | workbook as I have one workbook for each month of the year. | Is there a quicker method? |
All times are GMT +1. The time now is 01:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com