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