Office Companion throws policy check on save error

Symptom

Microsoft Prodiance Office Companion throws an error if you use "policy check on save" in Prodiance Enterprise Risk Manager (ERM) after you use Microsoft Prodiance Spreadsheet IQ's Clean Excess Formatting.

Resolution

As a workaround, follow these steps:

  1. Take a copy of the workbook offline (from the Microsoft Prodiance Office Companion) or disable Microsoft Prodiance Office Companion by following these steps:
    1. In the Excel menu, click Files, then Options and select Add-Ins.
    2. In the Manage drop-down menu, select COM Add-Ins, then select Go button.
    3. Clear Prodiance Office Companion.
    4. Click OK.
  2. Perform the Clean Excess Formatting by going to ProdianceSpreadsheet IQ and clicking Clean Excess Formatting.
  3. Once the Prodiance Spreadsheet IQ has finished, then close and save the file. Reopen the file back online, or re-enable Microsoft Prodiance Office Companion with the following steps:
    1. In the Excel menu,click Files,then Options and select Add-Ins
    2. In the Manage drop-down menu, select COM Add-Ins, then select Go button.
    3. Check the box next to Prodiance Office Companion.
    4. Click OK.
  4. Once the excess formatting has been cleaned and the file saved successfully, it should not be necessary to clean the excess formatting again. The policy check will run successfully on save.

Properties

Article ID: 2745473 - Last Review: 4 Dec 2012 - Revision: 1

Feedback