Tina Norris Fields
tinanfields at torchlake.com
Wed Jun 20 07:10:26 CDT 2012
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 >