Ask Your Question

auto refresh pitvot table after changes in source range [closed]

asked 2013-03-04 16:03:49 +0200

Wojtek gravatar image

updated 2020-07-30 00:39:16 +0200

Alex Kemp gravatar image

Is there a way to auto refresh pivot table after any change is made to the cells that are within selection range upon which Pivot Table is built?

EDIT: as per request - reported as bug/feature fdo#61793

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-27 01:47:49.373065


Tell you what I've noticed: Sometimes the tables DO refresh automatically; other times they only refresh when clicking on "Refresh" ... and at yet other times I need to go into "Edit Layout" before they refresh. There doesn't seem to be any consistency in this!

hrothgar gravatar imagehrothgar ( 2013-03-04 16:32:54 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-03-06 07:20:01 +0200

qubit gravatar image

Hi @Wojtek,

The documentation on Updating Pivot Tables says the following:

If the data of the source sheet has been changed, LibreOffice recalculates the pivot table. To recalculate the table, choose Data -> Pivot Table -> Refresh. Do the same after you have imported an Excel pivot table into LibreOffice Calc.

Based on your explanation, it sounds like you're experiencing a regression.

If installing the latest release doesn't seem to fix this problem, please file a bug and provide a list of steps that can reproduce your problem. The QA team will be happy to help you track down this issue!

Please post a link to any bugs you file in a comment below using the format "fdo#123456".


Note: It's possible that you could make some kind of workaround by getting a macro to poke Data -> Pivot Table -> Refresh after editing a cell, but please file the bug first so we can get started on fixing the underlying problem :-)

edit flag offensive delete link more


I've actually created ticket for same question there: fdo#61793 and got response, that it would be nice idea to implement. Bottomline - there is some discrepancy when it comes to functionality vs code vs documentation ;)

Wojtek gravatar imageWojtek ( 2013-03-15 09:03:55 +0200 )edit

Question Tools

1 follower


Asked: 2013-03-04 16:03:49 +0200

Seen: 3,620 times

Last updated: Mar 17 '13