I have a file with data going back till 2010. This results in lots of rows and a huge file size and a slow performance.
11681 rows and the size is 10MB.
I would like to reduce the file size.
My problem is that I have lots of pivot tables and reports based on all the data all the way back to 2010.
I could take all the rows until 2017 and paste them in another excel file, but then all my reports will not show data until 2017.
I have two questions:
1. Is there a way to significantly reduce the file size without removing the rows? maybe something to do with formatting (there's a lot of condtional formatting and generally formatting involved)
2. Otherwise, how would you split such a data file, so that you can still see all the data from 2010 till 2020 in one report?
Thanks
Bookmarks