Pivot Table Size

david meehan 1 Reputation point
2021-01-31T16:05:53.13+00:00

HI
I have a pivot table that connects to a SQL server DB.
If was to save the Pivot table with the underlying data the file would be 23,000KB
If I save the pivot without the underlying data (so you need to refresh it after opening- then the file would be 4,500KB
But if I just pasted as value what showing on the pivot as text into a workbook- the file would only be 11KB

What extra data is causing the pivot, without underlying data, to be so big?- It's causing a problem with an application I want to circulate- how can I get the pivot, without underlying data closer to the size of just the info being displayed as if there was no pivot table at all?

Hopefully, someone has a nugget for me..
Thanks
David

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,595 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,661 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Emi Zhang-MSFT 22,636 Reputation points Microsoft Vendor
    2021-02-01T09:27:50.617+00:00

    Hi @david meehan ,
    Try to select the PivotTable- go to PivotTable Analyze tab- Options- Data tab- uncheck save source data with file:
    62455-292.png


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. david meehan 1 Reputation point
    2021-02-01T12:26:45.32+00:00

    @Emi Zhang-MSFT
    Unfortunately not- that's what I was referring to when I said "I saved the pivot without the underlying data".
    So even with the tick box empty- and file saved- the pivot is causing the file to be >4,000KB

    0 comments No comments