Copying a Functional Pivot Table to New Workbook

[ffarber]

I want to copy a pivot table from a very complicated workbook to a new workbook so that I can distribute just the pivot table as a monthly report.

The pivot table is on its own worksheet in the original workbook. I can copy it to a new workbook using the copy/move tab functionality and selecting new workbook. However, the resulting workbook is a static representation of the data.

In Excel doing the equivalent operation results in a completely functional pivot table in the new workbook.

I am switching away from Microsoft to a linux system and am using version 7.3.7.2 of LibreOffice.

Thanks,
Fred

[Villeroy]

Use a template with the source table having the right column labels, some dummy records, the formulas, cell styles and with the pivot on another sheet.
Create a new document from that template. Insert new rows for the actual records in order to expand all references.

[ms777]

In Excel, there is an option “store data with the Pivot table”, which you have probably ticked, as the Pivot in the new workbook is completely functional. There is no such option in LO.

If being functional is a requirement for the new Pivot, copying both the data and the Pivot table is imo the only practicable option.