Hello: I have a workbook that contains one sheet that has the data and seven other sheets that have pivots. Each pivot's source data is the range of data from the datasheet.

Currently, the size of the file is approx. 33 MGs. Wow....... The data sheet currently has 169,641 rows and 37 columns. The row size is expected to increase a bit each day.

I'm looking to see how other's have dealt with this situation. My boss wants to have a datasheet to reference and even modify at times; otherwise, I would pull directly from the database.
I've thought about the possibility of splitting it out - where as the datasheet is in one workbook and the pivots are in another.

What do you think? Are there any other possibilities I'm missing?

Thanks for your help,
Proctor