| 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 |
| 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 | |||
Threaded Mode
