Restrict recalculation
I want to stop some, but not all, of the cells in a workbook from
recalculating. Is this possible -- Allizex |
Restrict recalculation
Using the VBE (Alt+F11) you can modify the properties (Press F4 if its not
already visible) of each indivudal sheet to allow/disallow calculations for that sheet. However, you can not disable calculation on a cell by cell basis. Due note that if your calculated sheet refers to a noncalculating sheet, your results will not be real-time accurate. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Allizex" wrote: I want to stop some, but not all, of the cells in a workbook from recalculating. Is this possible -- Allizex |
Restrict recalculation
Hi,
You can restrict recalculation to the cell by cell level if you write vba code. You would turn recalculation to manual first and then use a macro such as this: Sub myRecalculate() Selection.Calculate End Sub Assign a shortcut key like Ctrl+Shift+R to this and then anytime you want to recalculate a cell or range select it and press the shortcut key. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Allizex" wrote: I want to stop some, but not all, of the cells in a workbook from recalculating. Is this possible -- Allizex |
Restrict recalculation
Luke
This was really helpful, thanks. However, it only seems to work if the sheet is hidden. If its visible it seems to change the enable calculation field back to true. Am I missing something? -- Allizex "Luke M" wrote: Using the VBE (Alt+F11) you can modify the properties (Press F4 if its not already visible) of each indivudal sheet to allow/disallow calculations for that sheet. However, you can not disable calculation on a cell by cell basis. Due note that if your calculated sheet refers to a noncalculating sheet, your results will not be real-time accurate. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Allizex" wrote: I want to stop some, but not all, of the cells in a workbook from recalculating. Is this possible -- Allizex |
All times are GMT +1. The time now is 08:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com