Workbook file size cannot be reduced

[whoiswct]

My workbook only contain pivot tables and connect to another external data source.
The problem is that my workbook file size will become very large once I tired to connect a very large external data source.
How come the workbook (with pivot table but without data) file size so large?
How to reduce the file size of the workbook?

[ekavana186]

My workbook only contain pivot tables and connect to another external data source.
The problem is that my workbook file size will become very large once I tired to connect a very large external data source.
How come the workbook (with pivot table but without data) file size so large?
How to reduce the file size of the workbook?

Surprising but the entire data set is hidden within your sheet in order to make the pivot table function.