web query (external data) hangs 'orribly

I have created a web query on a sheetExcel 2003 Windows XP)

Please Login or Register  to view this content.

etc.....

This works perfectly when called as part of macro routines but if I am silly enough to click on that sheet, the sheet becomes non responsive for several minutes and I may need to use the task manager to shut Excel down.

I suspect it's sticking its nose up every link on the page (there are many)

Is there a parameter on the list that I can alter to make it cease and just deal with what's visible?

Is it this one (which is set to False?)

Please Login or Register  to view this content.