Hi There, I'm migrating a lot of files from one file share server to another. Excel files with VLOOKUPs have the current server name hard coded in the formula - so they break when moved to the new server. Does anyone know of a tool that can : run through directories recursively identify xls/xlsx files and 'open' perform find and replace on any cells with VLOOKUPS finding 'OLD_server_name/path_to_file/VLOOKUP_formula' and replacing with 'NEW_server_name/path_to_file/VLOOKUP_formula' Thanks

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Find and Replace Tool to change the path in VLOOKUP formula

Thread starter swandown
Start date Apr 30, 2021

swandown

New Member

Apr 30, 2021

Hi There,
I'm migrating a lot of files from one file share server to another.

Excel files with VLOOKUPs have the current server name hard coded in the formula - so they break when moved to the new server.

Does anyone know of a tool that can :

run through directories recursively
identify xls/xlsx files and 'open'
perform find and replace on any cells with VLOOKUPS finding 'OLD_server_name/path_to_file/VLOOKUP_formula' and replacing with 'NEW_server_name/path_to_file/VLOOKUP_formula'

Thanks