Building Dynamic BI Using Excel/SharePoint List Data – part 2

Since in Microsoft Office Excel 2007, the ability to synchronize data between Excel table and a SharePoint list is deprecated we need to download and install an add-in. The add-in then will enable us to update the information in a SharePoint list from Excel 2007.

The first thing we need to do is download and install the Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists into our Microsoft Office 2007 client application.

Please consult this MSDN paper as to how you can install the add-in into Office 2007 and publish the data to a SharePoint list.

Please note that you cannot save your Excel workbook in the new Office Open XML Formats (.docx). Instead, to retain the functionality, you need to save the workbook in the Excel 97-2003 file format (.doc).

If you follow these steps you have now an Excel workbook that has a data and synced to a SharePoint list.

In my next and final blog I will explain as to how we can create the Visifire chart, to display the synced SharePoint list data, using SharePoint designer 2007.

enjoy

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.