Help, excel keep popping Windows Security Warning

[Lewis Koh]

Hi,

I am using Excel 2007. I'm using this function "=RCHGetTableCell("http://investing.money.msn.com/investments/company-report?symbol="&A13,1,"Industry:")" to grab some data from the site but this site has changed. I have a few hundred cells using this function with different references. I think this is the cause of excel popping up the Windows Security Warnings saying "This page is accessing information that is no t under its control. This poses a security risk. Do you want to continue?" When I clicked either Yes or No, it will still pop up the next warning and I can't work with my excel to change the invalid cells now. Anyone experience this before?

Regards

[mehmetcik]

Try:-

Please Login or Register  to view this content.

[Lewis Koh]

HI, sorry, how do I use the text?

[Vikas_Gautam]

Okay you have to change Trust settings to low..
There is setting of EXTERNAL CONTENT ..
Switch it to enable all contents..

you should have a look at all settings in Trust Settings having possible connection with your problems..



Regards,

[Lewis Koh]

Okay you have to change Trust settings to low..
There is setting of EXTERNAL CONTENT ..
Switch it to enable all contents..

you should have a look at all settings in Trust Settings having possible connection with your problems..



Regards,

I have Disabled "All Data Connections" and " automatic update of Workbook Links" but the pop up still appears.

[Lewis Koh]

duplicated

[Vikas_Gautam]

I have Disabled "All Data Connections" and " automatic update of Workbook Links" but the pop up still appears.

why Disabled..?
you have to enable the data connections...


Regards,

[mehmetcik]

I assumed you were using a macro.

You need to insert that at the start of your macro.

[Lewis Koh]

Hi sorry. I enabled "All Data Connections" and " automatic update of Workbook Links", the warning messages still pops up.
mehmetcik, I didn't use macro.

[Lewis Koh]

...it's happening again....I'm not sure why. For a while it disappeared.