Forum Discussion
Excel Pivot Table Data Refresh Taking Over 10 Minutes
I just joined because I was searching for an answer to the same problem you are having. Have you heard anything? I don't see any responses... We have tried calling Excel directly... and I cannot find an answer. The go-around I discovered is to leave all the files you are linking to open and then refresh your file with the pivot table. It works fine then... but is a complete nuisance to have so many files open!
88Pelicans unfortunately i have had no response/help with this from the community or from Microsoft. The only solution i have is to use the older excel software (as per my original post). What i don't understand is that this worked fine (even on the current software) up until a few months ago, i can only assume Microsoft did a software update that changed something. If i get time i may see if its possible to reverse some of the updates and see if that helps, but i think its bad form on Microsofts part to create a problem and then leave it to their customer to create a "fix" for it.
