Link to many fields of text from excel with frequently updated workbook locations?

Copper Contributor

Is there any way to quickly update the source file for multiple links at once? I'll effectively be updating approximately 50 links/cells of data once a month going from C:\...\2023\January\01_File_Name to C:\...\2023\February\02_File_Name.

 

Preferably not using a macro.

 

2 Replies

@msoups You could toggle on the display of the field codes (ALT+F9) and then use the Find and Replace facility to modify the path\filename in the fields.  Then toggle off the display of the field codes and use CTRL+a to select everything in the document and then F9 to update the fields in it.