I have one LO calc file with severall sheets:
- one sheet with my “transactions” : a few columns and many rows. The data is “referenced” within a named range to be used in several pivot tables, so that the pivots have no issues if i add new records.
- 16 other sheets having different pivot tables, all analysing data of the same unique named range from point 1.
I would like that all these pivot tables automatically refresh when I open the file, so that I don’t have to go manually in each single pivot table to refresh the data (Right-click > Refresh).
in MS Excel 2007 I can tick a check box in each single pivot table properties for this auto-update at file opening.
See this screenshot from Excel which I would like to find in LibreOffice:
Has anyone any advices?
Thanks in advance
Libre Office Calc 184.108.40.206