This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 96%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
We are migrating Excel files from the shared 'T' drive to a Sharepoint site. The Sharepoint site is mapped to the 'S' drive.
All macros on spreadsheets are broken because the path change. Is it possible to update the path in batch? Thanks
I am checking to see how things are going there on this issue.
If there's anything you'd like to know, don't hesitate to ask.
Hi
This thread has been around for a long time. Please remember to accept them Answer if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.
Thank you for understanding! If you have any questions, or updates, please feel free to let me know.
Hi @Sean Su
If you find any reply helpful, please remember to accept it as answer.
It will help others who meet similar questions in this forum. Thank you for your understanding.
There is no way to modify the path in the macro file in bulk.
You can only manually change the paths in each file one by one.
This can be a time-consuming process, but it cannot be avoided.