| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Change (link) Source take hours? | Excel Discussion (Misc queries) | |||
| Formula Link References Change to Startup Directory | Links and Linking in Excel | |||
| Change link in pivot table | Excel Worksheet Functions | |||
| How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) | |||
| How to change the source of a link- Instructions were followed. I. | Excel Worksheet Functions | |||
Hybrid Mode
