I have a main site from which new subsites are created whenever a new project is started. In each of these sites there's an Excel standard document where people fill in data about that specific project.

My goal is to create a database list in the main site that is automatically update with the content from those Excel files located in each project subsite.

I've seen many ways to transfer data from Excel to a list, but none of them worked so far.

Is this possible to be done?


Hmm... How about adding VBA code to the Excel document? On save, it will sync its content with the SharePoint list on the main site. You'll obviously need to convert the Excel file to .xlsm if it's not already in that format.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.