SharePoint Tip: Are your old workbook taking a long time to load in SharePoint? Try updating them to 2013 to take advantage of .

Whether you are using or Server, SharePoint is able to store all sorts of files including previous versions of Office documents. However, in order to use some of the updated features in SharePoint you may need to update your Office document to the latest Office version. For more information about Office backward compatibility for read Microsoft’s Business Productivity at Its Best white paper.

One new feature that was introduced in SharePoint 2010 and is subsequently available in is Microsoft PowerPivot. PowerPivot can be used with SharePoint and Excel documents to work with over a million rows of data in seconds and integrate reusable data from different sources. PowerPivot is automatically available in SharePoint Online on Office 365. To use PowerPivot on Microsoft SharePoint Server it must be installed on your SQL Server. By upgrading your Excel document to the latest version of Excel, your Excel workbook can take advantage of PowerPivot and can load large workbooks in seconds instead of minutes.

For more information on how to try using PowerPivot today please visit Microsoft’s official PowerPivot website and How to download and install PowerPivot.

  • User Ratings (0 Votes)

About Author

Christine Weaver has been the technical lead on projects designing, developing, deploying, supporting, and delivering solutions for SharePoint since 2003. Christine’s knowledge and experience leans heavily on her 10+ years as a software consultant and from being a Microsoft certified professional. Christine has been a regular presenter at TechDays Canada and runs the Halifax SharePoint User Group.

Leave A Reply