Microsoft Projectis a tool used by enterprises and project managers to plan projects.

Sometimes these files need to be shared with your co-workers.

But you cannot expect everyone to have Project installed, right?

sync-ms-project-with-sharepoint

Guess what everyone already has in your organization?

So, whoever needs these files can access them from your SharePoint site.

SharePoints features just do not cease to amaze us, right?

sharepoint-site

So, lets jump right in and see how it is done.

You must sync it to an empty list on a SharePoint server.

This does not mean it’s crucial that you create a new SharePoint site.

sharepoint-new-list

If you have an existing site present, this should work too.

Next, you must jump in to the same Microsoft account in Microsoft Project.

Then it will use the same account to locate your SharePoint site and sync the data there.

sharepoint-blank-list

Finally, you should aim to sync the project files after you have made the final major changes.

This means you will save it to SharePoint and delete the main files on Microsoft Project.

You surely do not want anything like that.

sharepoint-list-details

after you snag ensured these, follow the steps listed below.

These steps will sync Microsoft Project into your SharePoint site:

Our work on SharePoint is done.

Now we need to link this SharePoint list with the Microsoft Project file.

microsoft-project-file

This process can take some time, depending on how much data you save to the cloud.

Lets move on to SharePoint now.

The Project data should be present there.

microsoft-project-save-as

Now lets go through what happens if you make some changes to the file on Microsoft Project.

This is because SharePoint treats the data as a simple list.

It just acts as a simple table or container to hold the data.

microsoft-account-log-in

What if you Cannot Sync MS Project to SharePoint?

Microsoft provides some known issues that can happen when you cannot sync your Project data to SharePoint.

I have described this below, which should help you if you face an error.

microsoft-project-sync-sharepoint

If your project has lots of tasks (exceeding1000), SharePoint can have trouble syncing them all.

In that case, breaking the large file into smaller files and then syncing them is a better idea.

For example, create separate plans and files for different departments.

microsoft-project-data-sharepoint

This clears up your site too.

Sometimes SharePoint lists require a mandatory field to be present.

This is usually the very first field that is automatically created.

If the field is missing, try adding the same field, and now the data should sync.

As mentioned earlier, SharePoint list does not like formulas.

In that case, remove the formulas from the Project file and then attempt to sync.

Summary tasks containing certain characters/:*?<>|do seem to introduce errors during Sync with SharePoint.

Try removing them or renaming the folder, which is supported in SharePoint.

When SharePoint does not find these, it can throw out errors during the syncing.

Frequently Asked Questions

Can Microsoft Project be used on SharePoint?

Yes, you might use a SharePoint list to save a Microsoft project file.

That way, anything you update there will be reflected in the Microsoft project file.

How do I open a Microsoft project file on SharePoint?

Once inside the Project file, navigate to File > Save As > Sync to SharePoint.

Here choose between a new site or an existing one, providing your SharePoint site address.

After this, the file will be saved on the SharePoint site as a list.

Closing Words

SharePoint, as its name implies, makes file sharing among your colleagues effortless.

That is no different when you bring your Microsoft Project files too.

I hope this article provides you with some valuable knowledge on SharePoint.

See you in some other guide in the future.