Bug 128131 - PIVOTTABLE: (option to) make Pivot Table refresh after opening a file
Summary: PIVOTTABLE: (option to) make Pivot Table refresh after opening a file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
Reported: 2019-10-14 05:30 UTC by Cor Nouws
Modified: 2019-10-15 00:24 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Cor Nouws 2019-10-14 05:30:02 UTC
Spreadsheet with pivot table
change some data in the source
  pivot table is not automatically updated/refreshed
  (see bug 61793)
Save, close and reopen file
  >> pivot table still is not updated/refreshed

Having this work, would at least be a work around for mentioned bug 61793
If I'm well informed, it works like that in Excel too
Comment 1 m.a.riosv 2019-10-15 00:24:29 UTC
Hi Cor, time ago, I reported https://bugs.documentfoundation.org/show_bug.cgi?id=89531, to get all pivot tables updated in one step, now you need to go one by one to do it, I have some macro to get it form the Aoo forum.

I'm not sure this is the right way, but maybe could be similar to what happen with external links, a warning with the option for update.