This option is available in MS Office Excel as shown here:
It can be used to refresh not only the formulas in a spreadsheet but also all data sources e.g., Pivot Tables. Is there an equivalent in LO Calc?
Thank u.
Answer is now out of date!
1 Like
In the Tools menu, the submenu Cell Contents has a menu item Recalculate. That is what you are looking for. It has a shortcut key: F9 by default. For Pivot tables, there is another menu item called Refresh (in Data > Pivot Table).
In my installation, Calc is setup to auto-recalculate, so I should not have to press F9.
A hard recalculate can also be forced using CTRL+SHIFT+F9. Related help page. Not sure this offers any advantage in the case of a Pivot Table refresh being required.
It Not work…
Doesn’t work on my copy either…
Thanks that answers my question.
It not complete. I have many hint Pivot table in sheet. How i do it?