Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

automatic update/refresh of all pivot tables at file opening: how?

Hi, I have one LO calc file with severall sheets:

  1. 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.
  2. 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.

Has anyone any advices? Thanks in advance

automatic update/refresh of all pivot tables at file opening: how?

Hi, I have one LO calc file with severall sheets:

  1. 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.
  2. 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.

Has anyone any advices? Thanks in advance

Libre Office Calc 5.1.4.2

automatic update/refresh of all pivot tables at file opening: how?

Hi, I have one LO calc file with severall sheets:

  1. 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.
  2. 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:

image description

Has anyone any advices? Thanks in advance

Libre Office Calc 5.1.4.2