Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel - web queries - some ISP's get Script Error -- others work OK


07 Apr 2012   #1

W7 X-64 W8.1 X-64 Opensuse 13.1 W2003 Server
 
 
Excel - web queries - some ISP's get Script Error -- others work OK

Hi there
really strange error

Same laptop computer - same version of EXCEL (32 bit 2010)

Back home on ISP run Web query -- runs fine.

Some places with public (or even paid for) Wifi in UK or Belgium I- Get Script error --have to press OK 2 or 3 times before Web query continues (Query is fine - retrieves data etc).

I use these web queries quite a lot to retrieve things like Stock Exchange data from web in "semi" real time from various free sites like YAHOO or MSN Money (15 mins Market delay -- not paying a fortune for "level 2" type data for the trading I do - 15 mins is quite sufficient) but I want them to run without needing to press OK after Script error.

It's obviously not EXCEL or my Query or even IE.

Is there some setting that I need to change when using some of these other providers like the Wifi access you get in Railway stations and airports.

For example at St.Pancras station in London (Free Wifi service) while waiting for Eurostar trains I use the wifi service -- I always get the Script error here.

Anybody else got this type of problem

It's got to be something in the ISP servers settings about running scripts -- I've just about tinkered with every possible setting on IE8 and IE9 (and even IE10 on W8 CP).

Somebody is bound to say Use Firefox -- CAN'T because of Work compatability -- and also EXCEL pulls in the data via IE.

however if you can't do decent web queries it rather reduces the functionality of the Internet when you are travelling -- some of us need to do more than just "Bog Standard Surfing" or twiddling with thumbs on a smart phone.

Cheers
jimbo

My System SpecsSystem Spec
.

Reply

 Excel - web queries - some ISP's get Script Error -- others work OK




Thread Tools



Similar help and support threads for2: Excel - web queries - some ISP's get Script Error -- others work OK
Thread Forum
Word 2010-Mailings-Updating Excel Data-Office14/Queries & Permissions Microsoft Office
Solved Adobe Flash and Java Script don't work Browsers & Mail
Visual basic script doesn't work in gadget Gadgets
Excel 2010 Script error popup when getting data from Web Microsoft Office
Display Player Error: Object expected, Script Error Software
Excel 2010 and Web Queries Microsoft Office
script error when running a vbs script. Network & Sharing

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 05:26 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33