if i have my pivot table not set to refresh on open.
is there a way to refresh all of them at once. when i want them to be
refreshed?
does F9 do this?
from the help, F9 says this:

Calculates all worksheets in all open workbooks.
F9 followed by ENTER (or followed by CTRL+SHIFT+ENTER for array formulas)
calculates the selected a portion of a formula and replaces the selected
portion with the calculated value.

SHIFT+F9 calculates the active worksheet.

CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of
whether they have changed since the last calculation.

CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells
in all open workbooks, including cells not marked as needing to be
calculated.

CTRL+F9 minimizes a workbook window to an icon.





"Calculates all worksheets in all open workbooks" --- does this mean pivot
tables?



thanks for any help!