Hi!
I have a zillion references in a workbook to roughly five other workbooks, and they all take the form of:
=+'U:\TLC\TLC\ARO\2010 Budget\PPHD\[Dept Bgt 2010 Sales.xls]Summary'!C17
Lord nly knows why my wife still insists on putting that stupid "+" at the start, but moving on... I want to wipe out the portion of all those links of:
+'U:\TLC\TLC\ARO\2010 Budget\PPHD\
and replace it with
'
so it will always be simply looking in the local directory for these workbooks, but every time I try using find and replace instead of finding and replacing, I get an idiot popup file selection window entitled "Update Values:<blah blah blah>". All I want is for it to do what I am telling it to do as the format I am trying to force on the darned workbook is correct according to documentation!!!
Any help?
I have a zillion references in a workbook to roughly five other workbooks, and they all take the form of:
=+'U:\TLC\TLC\ARO\2010 Budget\PPHD\[Dept Bgt 2010 Sales.xls]Summary'!C17
Lord nly knows why my wife still insists on putting that stupid "+" at the start, but moving on... I want to wipe out the portion of all those links of:
+'U:\TLC\TLC\ARO\2010 Budget\PPHD\
and replace it with
'
so it will always be simply looking in the local directory for these workbooks, but every time I try using find and replace instead of finding and replacing, I get an idiot popup file selection window entitled "Update Values:<blah blah blah>". All I want is for it to do what I am telling it to do as the format I am trying to force on the darned workbook is correct according to documentation!!!
Any help?