Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to tell Excel to recalc, unconditionally, now?
It's easy to invalidate an Excel 2002 workbook, putting it into a
recalc-required state, yet Excel fails to do it. For example, I have a worksheet with thousands of UDF calls (=MyUDF(Param)). If I make an edit whose only impact is to change the value(s) of the UDF params, that kind of edit seems too oblique for Excel and it won't recalc. (Or if calc is set to Manual, the Calculate flag doesn't appear, so pressing F9 does nothing. Nor does toggling Manual/Automatic calc. Even if you set calc to Automatic, save and reopen the WB, it stays UNCALC'ed.) Yes, I know I could, say: Open the VBA editor, edit some code (introduce a syntax error, say), exit, recalc and invoke the error, reopen VBA, correct it, exit, and recalc again. But that kludge is not an answer I, or any user, will accept. So where's the Excel user instruction to recalc *unconditionally, now*? Thanks much. *** |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to tell Excel to recalc, unconditionally, now?
Ctrl-Alt-F9?
-- __________________________________ HTH Bob wrote in message ... It's easy to invalidate an Excel 2002 workbook, putting it into a recalc-required state, yet Excel fails to do it. For example, I have a worksheet with thousands of UDF calls (=MyUDF(Param)). If I make an edit whose only impact is to change the value(s) of the UDF params, that kind of edit seems too oblique for Excel and it won't recalc. (Or if calc is set to Manual, the Calculate flag doesn't appear, so pressing F9 does nothing. Nor does toggling Manual/Automatic calc. Even if you set calc to Automatic, save and reopen the WB, it stays UNCALC'ed.) Yes, I know I could, say: Open the VBA editor, edit some code (introduce a syntax error, say), exit, recalc and invoke the error, reopen VBA, correct it, exit, and recalc again. But that kludge is not an answer I, or any user, will accept. So where's the Excel user instruction to recalc *unconditionally, now*? Thanks much. *** |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to tell Excel to recalc, unconditionally, now?
Hi,
Actually Excel has 4 non-VBA ways to recalc a spreadsheet, you could try any of these and see if they work: F9 (you've already tried this one) Shift+F9 Ctrl+Alt+F9 Shift+Ctrl+Alt+F9 No kidding! -- Cheers, Shane Devenshire " wrote: It's easy to invalidate an Excel 2002 workbook, putting it into a recalc-required state, yet Excel fails to do it. For example, I have a worksheet with thousands of UDF calls (=MyUDF(Param)). If I make an edit whose only impact is to change the value(s) of the UDF params, that kind of edit seems too oblique for Excel and it won't recalc. (Or if calc is set to Manual, the Calculate flag doesn't appear, so pressing F9 does nothing. Nor does toggling Manual/Automatic calc. Even if you set calc to Automatic, save and reopen the WB, it stays UNCALC'ed.) Yes, I know I could, say: Open the VBA editor, edit some code (introduce a syntax error, say), exit, recalc and invoke the error, reopen VBA, correct it, exit, and recalc again. But that kludge is not an answer I, or any user, will accept. So where's the Excel user instruction to recalc *unconditionally, now*? Thanks much. *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Recalc or NOT | Excel Discussion (Misc queries) | |||
Excel 2003 recalc issue | Excel Discussion (Misc queries) | |||
Why does an Excel Recalc cause traffic over Network ? | Excel Discussion (Misc queries) | |||
Excel auto recalc is occuring with no change to data. Help! | Excel Discussion (Misc queries) | |||
Automatic Recalc | Excel Worksheet Functions |