Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Security Issue: Data Connections Disabled

Hello,

I have a problem with some Excel Sheets that always have the following
warning: "Security Warning: Data Connections have been disabled" which block
any attempt to connect to that Excel Sheet (I'm trying to retrieve the data
into SSIS, but that's not the main issue). The thing is I click on "Options"
in front of that warning and set it to enable content and I save the file,
enabling extenal connections for as long as the sheet is open. As soon as I
close the sheet the new setting gets lost and it gets back to blocking the
external connections. Any clues for how to keep data connections enabled?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
remote connections John A Grandy New Users to Excel 1 May 26th 06 12:58 AM
Excel 2002 Security Issue PA New Users to Excel 2 December 3rd 05 03:32 PM
dynamic connections in excel? dennism Excel Worksheet Functions 1 September 16th 05 10:35 AM
Can the "Link to data in another Workbook Dialog Box" be disabled? PJF Links and Linking in Excel 2 July 13th 05 01:01 AM
How do I set up a database with Excel with connections between se. Veniceknight Excel Worksheet Functions 1 February 20th 05 10:38 AM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"