Dear Excel Gurus,
I have an Excel 2007 file that has about 15 tabs. It is about 5Mb total in size. It has one large table (about 7000 rows and about 20 column) and a bunch of pivots and smaller tables that "feed off" the large table. The file also has one pretty simple macro in it (I recorded it: it just sorts one of the smaller tables based on several criteria)
My problem is that whenever have to "filter" or "unfilter" either the large table or one of the smaller tables, it takes many minutes for Excel to do it. (It shows a "sand clock" for a really long time). This happens even when I am working with one of the smaller tables (tables that have about 300 rows and between 2 and 10 columns). By "filter" I mean that I select specific values in a specific column, so table shows only those rows that have one of the selected values in that column. By "unfilter" I mean that I select "all" values in the column.
The tables do have some simple computations (countifs, countblanks and the like) in some of the columns
I cannot post the file here because it contains corporate data.
Does anyone have any ideas on how I can improve the performance of Excel? I do not think I had this problem before. I am wondering if I somehow slowed things down by inserting the macro and saving the file as macro-enabled.
Studiosa.
P. S. I will be away from my computer next week, so I apologize in advance if I do not respond right away.
Bookmarks