Hi All,
I have a workbook that is pulling information from many other spreadsheets in a folder on my network. Can I find the current path and replace all with the new path? I assumed I could but once I do the search and replace all a "Update Values" dialogue window pops up wanting me to select a spreadsheet. This makes no sense to me. What am I missing?
Is there an easier way to do this that wont require me to paste in the new path 200+ times?
Thanks for your help!
Les
Bookmarks