You can ask Excel NOT to save the copy of the data and save on file size. This increases the file size and also slows down the open / close operations. Pivot Table creates a copy of the source data and saves it in the file. It relates to files containing one or more Pivot Tables. Although there are many reasons for large Excel files, one of the reasons is easier to manage and it is largely unknown. During the discussion, one of the problems we discussed was large Excel files. Today I was conducting an efficiency optimization session for Risk Management team of a global bank. Pivot Table Duplicate Cache Removal tool.It is designed for external connections.
