HOW TO CHANGE A LINK IN A FORMULA
 

Hello,

I have a spreadsheet with hundreds of cells containing, with slight
variations, the following formula:

IF(ISERROR(VLOOKUP($C8,'W:\[WIPSUM.xls]WIPSUM'!$B$2:$AJ$2000,21)),"0",VLOOKUP($C8,'W:\[WIPSUM.xls]WIPSUM'!$B$2:$AJ$2000,21))

This formula is pointing towards the file name WIPSUM.xls in drive 'W'.

How can I change drive from 'W' to drive 'Y' in all the cells that contain
such a formula in one go? As the correct file reside in drive Y instead of W

Thanks
Shahid

HOW TO CHANGE A LINK IN A FORMULA
 

Edit|Links|change source

or maybe select the range to fix and
edit|replace
what: W:\[WIPSUM.xls]WIPSUM
with: y:\[WIPSUM.xls]WIPSUM
replace all

(give enough of that string so that you don't change other things that are
important.

SSJ wrote:

Hello,

I have a spreadsheet with hundreds of cells containing, with slight
variations, the following formula:

IF(ISERROR(VLOOKUP($C8,'W:\[WIPSUM.xls]WIPSUM'!$B$2:$AJ$2000,21)),"0",VLOOKUP($C8,'W:\[WIPSUM.xls]WIPSUM'!$B$2:$AJ$2000,21))

This formula is pointing towards the file name WIPSUM.xls in drive 'W'.

How can I change drive from 'W' to drive 'Y' in all the cells that contain
such a formula in one go? As the correct file reside in drive Y instead of W

Thanks
Shahid

--

Dave Peterson