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.

[ffarber]

I am not sure I follow this. The right column labels change as people use the pivot table. I also, don;t want off-workbook references as that defeats the purpose.

[ffarber]

Yes, I have the check mark for data following the pivot table. Thanks for reminding me about that. I guess I will have to distribute the static data or copy the final data table. It wold be complicated but work. Thanks again.

[Villeroy]

If your pivot is a report from some kind of database, you may distribute pivot tables pulling its source data from a database document which is connected to the database. You don’t even have to export data from database to spreadsheet. Instead, you would get “live data” directly from the database as long as the database is reachable over the network.