Worksheet performance is slow after data volume has gone up 5 times
Hi,
We have summary worksheet which lists all the productlines. We use 'Open With' functionality to limit the data a user wnats to see.
When we added more product lines - the same worksheets are now crawling. Please advice how to get started to debug the performance. The data in the SALES_DATA has increased from 1 milion to 10 million records. We suspect that we can get get back the performacne if we can figure out the two questions. Please advice how to find the two answers. Any tips to get back the performance would be helpful.
1) Do I have older Sales_Data or Audit_Trail/Audit_Values information that are not necessary?