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.

Join the Good Gear Guide newsletter!

Error: Please check your email address.
Rocket to Success - Your 10 Tips for Smarter ERP System Selection

Tags applicationsMicrosoftsoftwareOffice suitesSoftware as a servicecloud computinginternet

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Juan Carlos Perez

IDG News Service
Show Comments

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Matthew Stivala

HP OfficeJet 250 Mobile Printer

The HP OfficeJet 250 Mobile Printer is a great device that fits perfectly into my fast paced and mobile lifestyle. My first impression of the printer itself was how incredibly compact and sleek the device was.

Armand Abogado

HP OfficeJet 250 Mobile Printer

Wireless printing from my iPhone was also a handy feature, the whole experience was quick and seamless with no setup requirements - accessed through the default iOS printing menu options.

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?