Menu
Office 365 admins get spreadsheet search help

Office 365 admins get spreadsheet search help

The new capabilities are aimed at companies struggling to manually maintain a comprehensive inventory of critical spreadsheets

Microsoft has switched on special search features in Office 365 designed to help IT administrators keep tabs on employees' spreadsheets, a task becoming more difficult and more important in enterprises.

The new capabilities are aimed at Office 365 customers who are having a hard time manually maintaining a comprehensive and up-to-date inventory of critical spreadsheets used for sensitive business processes.

By porting functions from the Office 2013 Discovery and Risk Assessment on premises server to the Office 365 cloud search engine, Microsoft expects to automate Excel "spreadsheet management" tasks, including identifying and categorizing important ones.

After crawling a company's files looking for spreadsheets, this new tool analyzes them and rates their complexity, impact to the organization and risk.

"In addition to giving you new insights about your spreadsheets, this capability combines with SharePoint Search and other Office 365 features -- like eDiscovery, archiving, and data loss prevention -- to give your organization much greater control of your information," wrote Steve Kraynak, Microsoft program manager for Excel spreadsheet management.

Spreadsheet elements that the Discovery and Risk Assessment software analyzes include the number of unique formula sets, individual formulas, sheets, data connections and linked workbooks, along with the path and file name of all linked workbooks. With this information, IT admins can become aware of spreadsheets whose integrity depends on access to files on someone's local hard drive, and spreadsheets that, when altered, trigger changes in others linked to them.

They will also get a snapshot of spreadsheets that tap external sources of data, and of spreadsheets with the highest complexity, which are probably also the most important to the organization.

These search properties are accessible via any search box in SharePoint Online, as well as on the Office 365 eDiscovery Center in the suite's admin console. Eventually, Microsoft will create a "search experience" specifically for these types of queries.

By strengthening security, data prevention, information management and compliance features in Office 365, Microsoft caters to the needs of CIOs and their large enterprises. It also differentiates the suite from competitors that don't focus so much on security and IT management, like startups that are trying to carve a niche for themselves by building next-generation mobile and cloud word processors, spreadsheets and presentation apps.

Juan Carlos Perez covers enterprise communication/collaboration suites, operating systems, browsers and general technology breaking news for The IDG News Service. Follow Juan on Twitter at @JuanCPerezIDG.


Follow Us

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags cloud computingMicrosoftinternetsoftwareapplicationsSoftware as a serviceOffice suites

Featured

Slideshows

The making of an MSSP: a blueprint for growth in NZ

The making of an MSSP: a blueprint for growth in NZ

Partners are actively building out security practices and services to match, yet remain challenged by a lack of guidance in the market. This exclusive Reseller News Roundtable - in association with Sophos - assessed the making of an MSSP, outlining the blueprint for growth and how partners can differentiate in New Zealand.

The making of an MSSP: a blueprint for growth in NZ
Reseller News Platinum Club celebrates leading partners in 2018

Reseller News Platinum Club celebrates leading partners in 2018

The leading players of the New Zealand channel came together to celebrate a year of achievement at the inaugural Reseller News Platinum Club lunch in Auckland. Following the Reseller News Innovation Awards, Platinum Club provides a platform to showcase the top performing partners and start-ups of the past 12 months, with more than ​​50 organisations in the spotlight.​​​

Reseller News Platinum Club celebrates leading partners in 2018
Meet the top performing HP partners in NZ

Meet the top performing HP partners in NZ

HP has honoured its leading partners in New Zealand during 2018, following 12 months of growth through the local channel. Unveiled during the fourth running of the ceremony in Auckland, the awards recognise and celebrate excellence, growth, consistency and engagement of standout Kiwi partners.

Meet the top performing HP partners in NZ
Show Comments