Home > Uncategorized > Spreadsheet Audit and Control in SharePoint 2013 Preview

Spreadsheet Audit and Control in SharePoint 2013 Preview

One of the Great New Things (TM) in SharePoint 2013 is the technology Microsoft acquired from Prodiance. This allows organisations to discover and audit the spreadsheets within their organisation. The spreadsheets could be tracked based on number of attributes (some of the more relevant to BI are data connections, conditional formatting, data changes in Pivot tables, file size). Once a set of critical spreadsheets are identified, users and IT administrators can compare spreadsheets
individually (pair-wise) for data consistency, formula errors etc. with Inquire in Excel. You can find out more here: http://blogs.office.com/b/microsoft-excel/archive/2012/07/26/office-business-intelligence-the-way-people-experience-data.aspx

However if, like me, you want to get the server bits for this and evaluate them, it can be quite tricky to actually work out what to download. Well, this is what you need:

http://www.microsoft.com/en-us/download/details.aspx?id=30353

 

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: