Thread: [Solved] Web queries
View Single Post
 
Old 09-27-2016, 04:38 AM
frankiefrankiefrankie frankiefrankiefrankie is offline Windows 10 Office 2013
Novice
 
Join Date: Sep 2016
Posts: 2
frankiefrankiefrankie is on a distinguished road
Default Web queries

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.
Reply With Quote