Small excel 2007 macro-enabled file takes 5 minutes to open on a fast computer, why?

[hurricaneditka16]

I have an unbelievably slow opening excel 2007 macro-enabled workbook that is only 950kb in file size. It’s got 2 worksheets, one is empty, and the other has about 1,000 records spanning 10 columns. The file also contains 3 short macros, one of them being a web data query. I’m trying to figure out why the file opens so slow (like 5mins). If it's the web data query macro code, I would like to know why.

 

[tweedle]

If it's the macros, then the size of the data file doesn't matter much.
I think you're headed the right direction with the web-query.
[Could track the date-time-stamp just before the web-query kicks off and just after it completes to verify it's duration.]
What happens when it opens without the macros?
As to 'why?'...that will be tough.
Could depend on the load of the web-server at the time, network traffic or any of a 1000 other things.

 

[hurricaneditka16]

the web query doesn't run on file open. no macros run upon the file opening. not sure if that's what you're saying.

thanks for the response.