How To - Update Linked Spreadsheets After A OneDrive Migration
The following YouTube video shows how to update macros and VLOOKUPs in linked spreadsheets that need to be fixed after a OneDrive migration because the X:\folder\file paths are no longer valid.
https://www.youtube.com/watch?v=kB6VEGtNdcQ