Replace worksheet name in formula linked to a different workbook

[Guest]

When I try to use Find/replace to replace the worksheet name to formula's
linked to many different workbooks, but the worksheet name is the same. It
gives us an update values box with the file name and wants us to locate the
files.

Ex: ='R:\BSP Auditing\FF Div Loan Pwd Surr\[FF Div Auditing.xls]SEP'!$E$39
(It is for multiple files and folders all under BSP Auditing.)

Want to change to: ='R:\BSP Auditing\FF Div Loan Pwd Surr\[FF Div
Auditing.xls]JAN'!$E$39

 

[Dave Peterson]

Just a guess.....

Are you absolutely positively sure that there's a worksheet named Jan in that
workbook?

The only way I could get that prompt is to not have that worksheet there (or
misspell part of the name (drive/path/filename).

When I try to use Find/replace to replace the worksheet name to formula's
linked to many different workbooks, but the worksheet name is the same. It
gives us an update values box with the file name and wants us to locate the
files.

Ex: ='R:\BSP Auditing\FF Div Loan Pwd Surr\[FF Div Auditing.xls]SEP'!$E$39
(It is for multiple files and folders all under BSP Auditing.)

Want to change to: ='R:\BSP Auditing\FF Div Loan Pwd Surr\[FF Div
Auditing.xls]JAN'!$E$39