About Health Check

Use the Health Check tool in Oracle Smart View for Office to optimize performance in a Microsoft Excel workbook, Word document, or PowerPoint presentation.

The actions you take with the Health Check tool will fix and/or delete some non-Smart View-related objects, optimizing Smart View performance.

You can also use the Health Check tool to get information about specific items in each Office application, such as named ranges, styles, tags, query objects, and other objects.

You access the Health Check dialog in the General group in the Smart View ribbon.

Health Check Items for Microsoft Office

When you launch the Health Check dialog, a copy of the selected Excel workbook, Word document, or PowerPoint presentation opens, and the dialog lists the following items:

• Workbook Health Check for Microsoft Excel

  • Named Ranges

  • Shapes

  • Styles

  • Links

  • Hyperlinks

  • Sheets

• Document Health Check for Microsoft Word

  • Tables

  • Inline Shapes

  • Shapes

  • Styles

  • Query Objects

    Note:

    To improve performance, click Fix to remove duplicate queries for data points pasted into Word.

  • Hidden Query Objects

  • Comment Objects

  • Variables

  • Bookmarks

  • Content Controls

• Presentation Health Check for Microsoft PowerPoint

  • Shapes

  • Tags

  • Slides

You can preview each item and delete or fix the items accordingly. Any changes are made in the copy of the Microsoft Excel, Word, or PowerPoint document. Performing a Save will save your changes in the copy. To save the file with the original file name, you must close the original file, and then perform a Save As.

Narrative Reporting: If you want to perform a health check and refresh a doclet of any Office type (described in Performing a Health Check on Microsoft Office Documents), perform the health check first, and then save the temporary file with the correct doclet name. Next, upload and check in the saved doclet (see Checking In Doclets. Then check out the doclet, perform the refresh, and then upload the doclet and check it in.