Dux Quax: How Can I Best Use Excel and SharePoint Synchronization?

In a project environment, Excel and SharePoint synchronization can be beneficial for budget tracking. Let’s say the PMO in your organization has a master Excel file tracking project expenses throughout the organization. In that file, there is a spreadsheet specific to your project, along with other spreadsheets pertaining to other projects. With synchronization enabled, the spreadsheet can be published as a list in your PMIS, and then anytime a new expense is entered into the Expense list in the PMIS, the PMO will see it on his spreadsheet. Conversely, if the PMO decides to enter new information into the spreadsheet, it will show up on the Expense list in your PMIS.