Updating a Sharepoint folder alongside and Shared Drive Folder

Question

I'll try to explain as best I can.

I have created an Excel sheet (creation sheet) that creates folders and files for multiple people at once, on my company's Shared Drive. The sheet itself creates a folder structure that follows a (person name>year>month) pattern, and then creates a excel file for the Week Commencing.

Recently the business are trying to move to sharepoint as much as possible.

I've tried to make it so the Creation sheet, uploads directly to sharepoint, but it doesn't like that. (If anyone has any tips on how to do this that would be great.)

Everyone's individual folders are stored in one "master folder". I was curious to see if it was possible, to have a folder on Sharepoint that automatically updates itself whenever there are any additions or changes to this "master folder" on the Shared Drive.

(I have had a look at syncing, I'm not a a sharepoint expert, but I don't think this is what I'm after, but if there is more to it please let me know)

Thanks

Answer 1

Hi @Jack O'Sullivan ,

According to your description, you have learned about Sync, which is the official recommended method:

https://support.microsoft.com/en-us/office/sync-sharepoint-and-teams-files-with-your-computer-6de9ede8-5b6e-4503-80b2-6190f3354a88

https://support.microsoft.com/en-gb/office/view-sharepoint-files-in-file-explorer-66b574bb-08b4-46b6-a6a0-435fd98194cc

But it does not satisfy you.

Then you can try Map SharePoint as a Network Drive (https://www.sharepointdiary.com/2019/09/map-network-drive-in-sharepoint-online-using-powershell.html)

or Add SharePoint Document Library to “Quick Access” in File Explorer (https://www.sharepointdiary.com/2019/01/how-to-add-sharepoint-to-quick-access-in-windows-10.html).

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.