I have a few cells that are related to other worksheets / books, etc. with standard Excel formulas. However, is there a macro that I can run when it only allows these cells to run? I want to maintain their last value till I want to update them.
There are some options for you Tools -> Options -> Calculation tab (For Excel 2003, 2007 Can not set in) I'm not sure if any way you can edit them in VBA or not ...
Settings affect the workbooks that are open when settings are changed. If you are set to manual calculation, the formulas only update when you press F9, or you can update the current letter with Shift + F9.
Hope it helps
[edit] What other readings, it seems that you can adjust it using VBA:
< Pre> application.Calculation = (xlCalculationAutomatic | xlCalculationManual | xlCalculationSemiAutomatic) A calculation is the first asset that does this, it seems ...
Comments
Post a Comment