Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Each time I open an excel file that contains data imported into or dumped into the excel spreadsheet the following error message displays.
    "This workbook contains queries to external data that refresh automatically.
    Queries are used to import data into Excel, but harmful queries can be used to access confidential information or write information back to a database..."

    see screen capture

    I found a "fix" on microsofts website
    http://support.microsoft.com/kb/248204

    I'veimplemented the microsoft fix and changed the reg keys to 1 or 2, to not display the warning message. However no success.

    anyone come across this problem? how did you resolve?

    many thanks

    diana
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Have you quit and restarted Excel after adding/modifying the registry value?

    Have you made sure that the QuerySecurity value is in the correct registry key for your version of Office? It should be in:
    HKCU\Software\Microsoft\Office\9.0\Excel\Options for Office 2000
    HKCU\Software\Microsoft\Office\10.0\Excel\Options for Office 2002 (XP)
    HKCU\Software\Microsoft\Office\11.0\Excel\Options for Office 2003
    HKCU\Software\Microsoft\Office\12.0\Excel\Options for Office 2007

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hans

    Yes the correct office version registry key have been added
    and
    Ive closed & reopened Excel.

    The ms recommendations havent made a difference as the warning message still displays.

    The only difference is a new version of document management system, therefore it maybe related.

    Ill need to investigate further.

    as always...many thanks again Hans

    diana

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Ah - a new version of the document management system...
    Can't help with that.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the replies

    so... Ive applied the recommendation in article

    http://support.microsoft.com/kb/248204

    and the result is the Excel warning message still displays.

    Ive searched the web and this solution has worked for others.

    the update is...
    in the MS article it mentions the fix applies to the following versions of Office...

    APPLIES TO
    Microsoft Office Excel 2003
    Microsoft Excel 2002 Standard Edition
    Microsoft Excel 2000 Service Pack 1

    I dont think this should matter but the version Im appling the fix for is
    Microsoft Excel 2002 Professional SP3

    any ideas?

    diana

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The Document Management System probably interferes with Excel's "native" behaviour. I'd ask the developer of the DMS if they have a solution.


  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    ok will do...

    many thanks Hans


    diana

Posting Permissions

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