When a number of people start working simultaneously on a single Excel document, it can be quite difficult for everyone to do modifications. You’d end up encountering error messages, annoying pop-ups or program restarts. Syncing your Excel spreadsheets to a SharePoint site is just one way for you to handle modifications from one user to another, without the need to jump from one computer to another. The moment you publish your Excel list, you will see the two buttons on your List toolbar. This is where you will start the syncing process of your Excel spreadsheets.
- Skill level:
Other People Are Reading
Go to the List toolbar of your window. Click on "Synchronize List" in order to publish the local changes to your SharePoint list. This will bring up any changes that were made to the file down to your local Excel list.
Resolve the conflict on your list individually in case you see one between the changes that you made and the ones done by another local user of the SharePoint list. The Excel file will display the Errors dialogue box and Resolve Conflicts for you to start resolving the inconsistencies.
Click on “Discard My Changes” if you are using the changes of another local user to your SharePoint list; “Retry My Changes” if you want to override the changes of another user on the SharePoint list; “Discard All My Changes” if you want to keep all the changes made the other user; or “Retry All My Changes” if you want to override all the changes of another user on the SharePoint list.
Unlink your lists by removing the link to your SharePoint list on the window and clicking on Unlink My List. You may continue making changes to your Excel list but these will no longer be synched to the SharePoint site file.
Tips and warnings
- To discard changes or to refresh the list with new published changes, you can download a copy of the list from your Microsoft Windows SharePoint Services website.
- Note that synchronisation is not an automatic feature in your Excel file. You must manually discard or synchronise your local changes to the list. You will only be notified regarding the unsynchronized changes once you open the shared list.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for