Excel web query

D

Dave Patrick

Windows XP Professional SP-2, Office 2003 SP1

Only when I'm trying to get external data through excel in the "New Web
Query" window I continually get prompted;

'Security Information'
'This page contains both secure and nonsecure items.'
'Do you want to display the nonsecure items?'
'Yes' 'No' 'More Info'

If I open IE and browse to the same site and location I don't get prompted.

Does anyone know how to stop this message box from popping up?

IE|Tools|Options|Security|Custom Level
Under the Miscellaneous heading, the "Display mixed content" setting is set
to 'Enable'

--
Regards,

Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Web Query Macro - Mixed content prompt prevents script from loadin 0
Excel - Data - From Web - Error 0
Saving Excel as HTML 1
Secure and nonsecure items popups 5
Web Query 0
Hyperlinks in Word 2010 "Cannot download the information you requested" 0
The 2007 Microsoft Office system does not support upgrading from a 1
Open OneNote Web App in OneNote Desktop 2

Top