Is it possible to create an multi threaded application,
The lists all the pivot tables in an excel document,
And fires a new thread to refresh each pivot table.
Currently a applicatoin.refreshall takes 3hrs.
I also do not think that vba code can be mulithreaded.
Any ideas welcome
-
I'm not sure that making this process multithreaded would necessarily help. 3 hours is a pretty long time for anything - I suspect you have other problems with this excel document. How big is the file?
From MusiGenesis
0 comments:
Post a Comment