SYMPTOM:
Users cannot edit Strategy reports included in Word or PowerPoint as interactive embedded Excel workbooks. Instead, one of the following error messages appears:
This object is corrupt or is no longer available.
Or
The server application, source file, or item can't be found, or returned an unknown error. You may need to reinstall the server application.
In addition to these symptoms, Word or PowerPoint may crash.
CAUSE:
If a user configures Strategy Office to include reports as interactive embedded Excel workbooks, Strategy Office creates an embedded Excel workbook in Word and PowerPoint to display the report. There are several things that can cause the embedded objects to be corrupt. For example, a Norton AntiVirus Office plug-in is known to affect embedded workbooks. In addition, installing Microsoft Office service packs is known to cause problems with embedded objects.
ACTION:
Microsoft suggests disabling the Norton AntiVirus Office plug-in. To learn more about Norton AntiVirus Office plug-in and Microsoft Office, refer to the following Microsoft Knowledge Base article:
To learn more about installing Microsoft Office service packs and embedded objects, refer to the following Microsoft Knowledge Base article:
In some environments, closing Microsoft Excel before opening or refreshing any embedded workbooks in Word and PowerPoint may improve the behavior.
To remove the corrupted object, delete the corrupted Strategy Office reports in the Word document or PowerPoint presentation and re-execute the reports. Alternatively, refreshing the report will cause Strategy Office to delete the corrupt object and re-create it.
To delete the reports, perform the following:
WORKAROUND:
If it is not necessary to edit the Strategy Office reports in Word or PowerPoint, users can consider changing the configuration option to include the reports as pictures.
To change the configuration option, perform the following steps:
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.