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