So, my place of employment has decided to do away with local network drives, and to migrate all files on these drives to SharePoint. Seems like a good idea. I like the flexibility and security of sharepoint. My issue is that I have quite a few workbooks that reference other workbooks for data, whether in formulas or macros. I am not familiar with how to adjust these references so find the files on sharepoint. Is this a difficult task, or should I redesign my workbooks in a way that I don't need to reference other workbooks as much? Any ideas or tips?