What are some basic trouble shooting steps that I can take when receiving an error opening or working in a Microsoft® Excel® workpaper inside of CCH® ProSystem fx® Engagement or Workpaper Manager?
- Check for a hung instance of Microsoft® Excel®.
- Close all Microsoft® Excel® files.
- Right-click on the Task Bar and select Task Manager.
- Click on the Processes or Details tab and sort by Name.
- Right-click and choose End Process on any excel.exe processes.
- Replace the epace.xla addin.
- Rename the excel##.xlb file.
- Open Microsoft® Excel® outside of Engagement.
- Go to File > Options > Addins and verify that epace.xla and pfx.ribbon.exceladdin are active. If it is disabled, re-enable it.
- Add Workpapers to Microsoft® Office® Trusted Locations.
- Open a Microsoft® Excel® workbook and click File > Options > Trust Center > Trust Center Settings.
- Click Trusted Locations > Add New location.
- In the Path box, enter C:\Pfx Engagement\WM\Workpapers\.
- Select the check box Subfolders of this location are also trusted.
- Click OK.
- Select the check box Allow Trusted Locations on my network (not recommended).
- While the option is listed as "not recommended", if users are working with Microsoft® Excel® workbooks that originated on a network location, or linked from a network location, this option is required for functionality.
- Disable Protected mode.
- Open a Microsoft® Excel® workbook and click File > Options > Trust Center > Trust Center Settings.
- Click Protected View, and clear all check boxes.
- Set the Macro Settings.
- Open a Microsoft® Excel® workbook and click File > Options > Trust Center > Trust Center Settings.
- Click Macro Settings and select Disable all macros except digitally signed macros.
- Make sure that the user has appropriate rights to the folders in Microsoft® Windows®.
Note: These steps are for troubleshooting issues that happen on all Microsoft® Excel® workpapers. If the error occurs in only one workpaper in a binder, then these steps will probably not resolve the issue.
Solution Id | 000167278/sw7706 |
---|---|
Direct Link |