ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel web query (https://www.excelbanter.com/excel-discussion-misc-queries/36096-excel-web-query.html)

Dave Patrick

Excel web query
 
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]


All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com