Hi all,
I want to distribute a pivot table which has a link to a datasource connection. The datasource is updated every week with new data but the distributed version should be static when sent out.

What is the best way to build such a report with pivot functionalities yet the data behind it is not updateable. To import the data on a seperate tab is not an option because it exceeds over 100000 records.

Paul.

When you say the datasource is updated, I presume you mean it is overwritten, in which case the only way to keep the pivot table functionality is to store the data somehow. you could create a csv or text file from your data source, then have the pivot table reference this. or you could change the database so that data is not overwittten.

if it is not overwritten the change the query to have date constraints.