I even abandoned my pivot table and made a new one in the new file. I copied just the data into a brand new file on the 'good' computer, saved it there and brought it back to the 'problem' computer. So I moved on to trying Zot's suggestion. Doing that helped to make the file open quickly, but then it totally bogged down when I tried to filter the data. That seemed an easier thing to try first since one of my files with this problem has lookups between spreadsheets that might be time consuming to redo (if i copy each sheet into a new file). Thanks Zot and Rivi2628 so much for your replies! I tried first just doing Rivi2628's suggestion of the clearing the areas outside my data (there were a couple of shaded columns) and deleting the prefetch.
0 Comments
Leave a Reply. |