Category Archives: Excel

Synchronize Excel Data With SharePoint List

Versions:  SharePoint 2007, 2010 & 2013 The 2-way sync with Excel was there in SP2007 via an Add-In https://msdn.microsoft.com/en-us/library/bb462636%28office.11%29.aspx?f=255&MSPPError=-2147217396 http://www.microsoft.com/en-us/download/details.aspx?id=9345 The 2-way sync with Excel was allowed in SP2010 again w/SP2007 Add-In http://itblog.wolthaus.net/2012/03/synchronize-excel-2010-with-sharepoint-2010-list/ The 2-way sync with Excel was allowed in SP2013 … Continue reading

Posted in Excel, Lists | 2 Comments

Quickly Display ERP Data in SharePoint

Products:  SharePoint 2007, 2010 I worked with a client this past week that needed critical data from their ERP System (Oracle) displayed within the context of their intranet site for broader visibility, consumption and analysis. Solution Options BCS (Business Connectivity ServicesMy first thought was … Continue reading

Posted in Business Intelligence, Excel, User Adoption | Leave a comment

Use Excel 2010 & SharePoint 2010 To Build An Interactive What-If Analysis Tool

Products:  Excel 2010, SharePoint 2010 The Challenge A client requested assistance in providing an interactive what-if analysis tool for their business users.   The tool consisted of a few variable fields and a final estimated cost field. The Environment The users had … Continue reading

Posted in Business Intelligence, Excel, SharePoint | Leave a comment