Ask Your Question

Is there a Refresh All (Excel) button equivalent in Calc? [closed]

asked 2014-07-11 08:40:01 +0200

NYIT gravatar image

updated 2015-10-19 22:14:16 +0200

Alex Kemp gravatar image

This option is available in MS Office Excel as shown here:

Refresh All button

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 22:14:50.183065


Answer is now out of date!

WestNab gravatar imageWestNab ( 2019-01-26 13:19:30 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-07-11 09:01:45 +0200

bencomp gravatar image

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.

edit flag offensive delete link more



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.

oweng gravatar imageoweng ( 2014-07-15 06:09:32 +0200 )edit

It Not work...

NYIT gravatar imageNYIT ( 2014-07-15 08:46:46 +0200 )edit

Doesn't work on my copy either...

WestNab gravatar imageWestNab ( 2019-01-26 13:20:31 +0200 )edit

answered 2014-07-15 04:58:40 +0200

NYIT gravatar image

Thanks that answers my question. It not complete. I have many hint Pivot table in sheet. How i do it?

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-07-11 08:40:01 +0200

Seen: 24,509 times

Last updated: Jul 15 '14