+ Reply to Thread
Results 1 to 10 of 10

Help, excel keep popping Windows Security Warning

  1. #1
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    252

    Question Help, excel keep popping Windows Security Warning

    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

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,051

    Re: Help, excel keep popping Windows Security Warning

    Try:-

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    252

    Re: Help, excel keep popping Windows Security Warning

    HI, sorry, how do I use the text?

  4. #4
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Help, excel keep popping Windows Security Warning

    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,
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  5. #5
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    252

    Re: Help, excel keep popping Windows Security Warning

    Quote Originally Posted by Vikas_Gautam View Post
    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.

  6. #6
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    252

    Re: Help, excel keep popping Windows Security Warning

    duplicated

  7. #7
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Help, excel keep popping Windows Security Warning

    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,

  8. #8
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,051

    Re: Help, excel keep popping Windows Security Warning

    I assumed you were using a macro.

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

  9. #9
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    252

    Re: Help, excel keep popping Windows Security Warning

    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.

  10. #10
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    252

    Re: Help, excel keep popping Windows Security Warning

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel Security Warning
    By rong1 in forum Excel General
    Replies: 2
    Last Post: 03-17-2014, 08:25 PM
  2. [SOLVED] How do I stop a warning dialog box from popping up, using VBA
    By woodbridge1965 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-27-2013, 12:41 PM
  3. Replies: 1
    Last Post: 01-24-2013, 08:03 AM
  4. How to switch off Word Windows popping up while running a Macro
    By makku in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2011, 04:12 AM
  5. Replies: 0
    Last Post: 01-19-2006, 08:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1