I would like to propose an additional option in Pivot table properties "Auto refresh when source selection changes" which would basically trigger refresh of Pivot Table after any changes to the cells that are within selection range upon which Pivot Table is built.
Sure sounds like a good idea. Marking as New (valid enhancement request) Enhancement (not a bug, additional feature) Low (pivot tables aren't used a ton despite them being functional, this is just a way to make them slightly better as you can always refresh manually also the technical details might be a bit tough) @anyone who takes this - maybe using the "changed" trigger - ie if a document is changed and you can save it - to cause a refresh would work.
At the same time I've filled feature request I've started a topic on ask.libreoffice : http://ask.libreoffice.org/en/question/13770/auto-refresh-pitvot-table-after-changes-in-source/ and I've got response that... it should already work like that: The documentation on Updating Pivot Tables ( https://help.libreoffice.org/Calc/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." There was a suggestion that I should fill a bug request so I will only link those two threads. Curious thing - I've never noticed that pivot tables were updated automatically as per documentation.
Any progress?
The refresh of pivot table may take a while depending on system performance and amount of data. Having a global setting to automatically refresh should include an option to override per document to cover for those situations.
(In reply to Heiko Tietze from comment #4) > The refresh of pivot table may take a while depending on system performance > and amount of data. Having a global setting to automatically refresh should > include an option to override per document to cover for those situations. Yes, it can take a while, therefore an option at pivot table level could be the proper way. There are already 6 options like "ignore empty lines", "Enable drill to details" etc... I propose a 7th option "REFRESH DATA at FILE OPENING". With this option, everyone is responsible of his own performance, this is not LibreOffice Calc responsibility.
(In reply to Heiko Tietze from comment #4) > The refresh of pivot table may take a while depending on system performance > and amount of data. Having a global setting to automatically refresh should > include an option to override per document to cover for those situations. I agree, automatically recalculating after every change of a source table might takte too long and disturb the workflow. In cases where the data source is a SQL query, auto-update wouldn't be possible at all. However, providing a visual clue when a data source change could/has been detected would significantly improve usability and help in avoiding errors. Think e. g. some icon in the pivot tables top-left corner.
This feature would be most welcome. I have pivot tables based on linked files and it should be at least refreshed on opening as likely the data source has changed.
+1
*** Bug 148058 has been marked as a duplicate of this bug. ***