Hi,
I have an excel sheet with about 198,000 rows.
I use it to track sales and it has dates on it that I group. It is grouped with days, months and years.
Whenever I change the ending to either the current date or something later the file freezes and I get the message on the bottom of the screen that it's calculating the pivot table. It's stays stuck there.
Any help greatly appreciated!
I have an excel sheet with about 198,000 rows.
I use it to track sales and it has dates on it that I group. It is grouped with days, months and years.
Whenever I change the ending to either the current date or something later the file freezes and I get the message on the bottom of the screen that it's calculating the pivot table. It's stays stuck there.
Any help greatly appreciated!