[dba-Tech] Excel ? from reader

Susan Harkins ssharkins at gmail.com
Wed Jun 20 08:58:47 CDT 2012


Tina, it might just be the ticket -- I don't use the trust center at all, 
and therefore, I forget about it! Thank you -- I'll have him try this.

Susan H.


> Just looked into my Excel 2010 trust center options page - external 
> content.  The choices are:
> enable all data connections (not recommended)
> prompt user about data connections
> disable all data connections
> and:
> enable automatic update for all workbook links (not recommended)
> prompt user on automatic update for workbook links
> disable automatic update of workbook links
>
> In both sections, by default, the "prompt user" option is selected.  This 
> is probably the place to make the changes.  Hope this helps.
>
> T
>
> Tina Norris Fields
> tinanfields at torchlake.com
> 231-322-2787
>
>
> On 6/19/2012 11:53 AM, Susan Harkins wrote:
>>
>>
>> Excel file (I'll call it "parent").  When opened, some cells are linked 
>> to other Excel files, I'll call "child 1" and "child 2".  Actually, 140 
>> of them.
>>
>>
>>
>> Parent has a cell, let's say C15.  It contains: 
>> ='C:\[child1.xls]Sheet1'!$a15
>>
>>
>>
>> Child (children) are all password-protected.
>>
>>
>>
>> These were all created under Excel 2003, all worked fine.  Parent updated 
>> from children when parent was opened, never asked for password.
>>
>>
>>
>> Upgraded to Excel 2007, now opening parent prompts for a password for 
>> each child it tries to update from!  140 children.140 passwords.
>>
>>
>>
>> Any idea what happened?  Or how to fix?
>>
>>
>>
>>
>>
>> ===========Beats me -- anyone had this kind of experience after 
>> upgrading?
>>
>>
>>
>> Susan H.
>> _______________________________________________
>> dba-Tech mailing list
>> dba-Tech at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-tech
>> Website: http://www.databaseadvisors.com
>>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com 



More information about the dba-Tech mailing list