Tina Norris Fields
tinanfields at torchlake.com
Wed Jun 20 07:02:57 CDT 2012
Wow, what a hassle! I'm thinking there must be a programmatic way to provide the child passwords during the opening of the parent. Or, maybe even easier - look into the trust center options set for those files. There is probably a security option checkbox that should be cleared. I'll do a little looking, too. 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 >