Web queries

[frankiefrankiefrankie]

Hi people :-)



My spreadsheet contains a dozen web queries that get financial numbers from web pages.

They perform well when I run them individually.
But when they're run all at once (for example when the spreadsheet is being opened), Excel just sits there endlessly "connecting to web" and if I click anywhere Excel becomes "not responding".

Questions:
- Anybody knows what is could be going on and how it can be solved?
- Is there a maximum number of web queries for a single spreadsheet? (maybe a dozen is a bit too much?)
- Is there a better way to pull in financial numbers from misc websites?

P.S I use Excel 2013. Previously I used an older version and it didn't perform very well either.