Troubleshoot Microsoft Office add-ins for Workpapers CS

Scenario

#VALUE
or
#NAME
in cells.
Workpapers CS menu doesn’t appear on the toolbar or ribbon bar in Microsoft Excel.
Documents don’t automatically return to the binder. This means that the status of the workpaper remains
Checked Out
when you close the document.

Solution 1: If documents aren't returned to the binder

Right-click the workpaper, then select 1 of the following:
Discard checkout
if the document doesn’t include your recent changes.
Return to binder
, if the document includes your recent changes.
If you get an error message:
Check if there is a copy of the workpaper at
C:\Users\[your user name]\AppData\Local\Creative Solutions\Accounting CS\CheckedOutFiles
note
You may need to show hidden folders to view the AppData folder.
If there's a copy, make sure that the document's permissions aren't
Read-only
.

Solution 2: Check your version of Office

You'll need to run Office 32-bit. Refer to our Microsoft Guidelines for CS Professional Suite to check that we support the version of Microsoft Office you're running.
Check that you have only one version of Microsoft Office installed.
If you need to uninstall a version of Microsoft Office, refer to the Microsoft Support website to make sure you fully remove the installation.

Solution 3: Check you aren't running the application as an administrator

Close the application.
Right-click the application's icon on your Windows Desktop, then select
Properties
from the context menu.
On the
Compatibility
tab, verify that the
Run this program as an administrator
checkbox is clear.
important
If Windows User Account Control is turned off, Windows will run the application as an Administrator even if the
Run this program as an administrator
checkbox is cleared.
Check that the executable application file is not run as administrator:
Go to C:\Program Files (x86)\Creative Solutions\
Accounting CS
or C:\Program Files\Creative Solutions\
Accounting CS
.
Right-click on
AccountingCS.exe
, then select
Properties
from the context menu.
On the
Compatibility
tab, make sure the
Run this program as an administrator
checkbox is clear.

Solution 4: Check the Add-In is enabled

In Microsoft Excel, select the
File
tab, then
Options
.
Select
Add-Ins
.
Select
Excel Add-Ins
from the
Manage
dropdown, then select
Go
.
Make sure the Verify that the
Cs.Accounting.Excel.Automation item
checkbox is marked.
Select
OK
.
Repeat steps 1 and 2.
Select
COM Add-Ins
from the
Manage
dropdown, then select
Go
.
Make sure the
CS.Accounting.OfficeIntegration.ExcelVstoAddin
item checkbox is marked.
Select
OK
.
If the
CS.Accounting.Excel.Automation
and
CS.Accounting.OfficeIntegration.ExcelVstoAddin
items are not present:
Select
Disabled Items
from the
Manage
dropdown list.
Select the item, then
Enable
.

Solution 5: Review your Trusted Locations for Excel

In Microsoft Excel or Word, select the
File
tab, then
Options
.
Select
Trust Center
.
Select
Trust Center Settings
.
Select
Trusted Locations
.
Select
Add new location
.
Select
Browse
, go to C:\Program Files(x86)\Creative Solutions\
Accounting CS
, then select
OK
.
Mark the
Subfolders of this location are also trusted
checkbox.
Select
OK
.

Solution 6: Turn off any Add-Ins not in use

In Microsoft Word or Excel, select
File
, then
Options
.
Select
Add-Ins
.
Select
COM Add-ins
from the
Manage
dropdown list.
Select
Go
.
Clear the checkbox for any Add-Ins that you're not using.
Select
OK
.

Solution 7: Reinstall the application

On the workstation, go to
Control Panel
.
Select
Programs and Features
.
Select
Accounting CS
, then
Uninstall
.
Go to the WinCSI folder where you installed the application.
Open the
Accounting CS
folder inside the WinCSI folder.
Inside the DESKTOP folder, double-click Setup.exe.

Solution 8: Reset user interface

Select
Help
then
Reset User Interface Settings
to delete your Client Settings file and reset the settings.
Close and reopen the application.

Virtual Office/SaaS firms

Find and fix Add-In conflicts for local installation only

Open the Start menu and then type "regedit" in the search to open the Registry Editor. Regedit needs to be run as an administrator to make edits.
Browse to the HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins
Select on the first item in the add-ins folder.
Double-click LoadBehavior and then change the ValueData to 1 and select OK.
Repeat steps 2-4 for the following locations as well. Not all machines may have all the keys listed, check to see if they do exist and if any changes are needed (the last 2 keys may not be on most machines but double check anyway).
HKEY_CURRENT_USER\Software\Microsoft\Office\Word\Addins
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Word\Addins
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Software\Microsoft\Office\Excel\Addins
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Software\Microsoft\Office\Word\Addins
note
if the first item doesn’t have the LoadBehavior item, move down to the next item.
Close the Registry Editor and restart your computer. Once changes are made, make a backup of the registry in this “cleaned” state. This is needed as when some programs are updated, they will automatically change their registry settings. If that happens, users can restore the “clean” registry instead of going through the process again.

Error message: Unable to cast COM object

Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass; to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).

Error: not loaded. A runtime error occurred during loading of the Com add-in

Verify that the Add-In is listed in the Registry Editor in the following locations:
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins
Verify that the load behavior for the Add-In is set to
3
in both locations.
If you can't find the Add-In in the Registry Editor:
Uninstall and re-install Microsoft Visual Studio 2010 Tools for Office Runtime.
Reboot the workstation.
Rerun the Desktop Setup.

Document doesn't open in Excel or Word, but status changes to Checked Out

Go to
Control Panel
, then
Programs and Features
.
Check if there are remnants of an earlier version of Microsoft Office.
If so, uninstall, then reboot.
If you get the Workpapers error:
The system can't find the file specified
:
Open Excel or Word.
note
Windows should automatically launch an installer that will do some configurations.
Open the document from the Workpapers Dashboard.

Reset Excel settings

Enter
regedit
in Windows
Search bar
and select the
Registry Editor
app.
Go to HKEY_CURRENT_USER\Software\Microsoft\Office\
Rename the folder that corresponds to the version of Excel, for example rename 15.0 to 15.0.old.
Open Excel outside Workpapers CS, then within Workpapers CS.

Trend Micro

Confirm Agent Version for reference (should be at least 6.6.2412/14.1.1150).
Back up the CPMCONFIG.INI file in the %ProgramFiles%\Trend Micro\Client Security Agent\Hosted Agent\CPM folder.
Back up the OFCSCAN.INI file in the %ProgramFiles%\Trend Micro\Client Security Agent folder.
Unload Agent > Monitor in Services.msc if it has stopped.
Download and apply the fix SEG_66_Excel_AvoidExcelSaveIssue from box.
Restart the workstation.
Check if the files below have the AvoidExcelSaveIssue=0:
C:\Program Files (x86)\Trend Micro\Client Server Security Agent\HostedAgent\CPM\CpmConfig.ini [Global Setting]
C:\Program Files (x86)\Trend Micro\Client Server Security Agent\Ofcscan.ini [Global Setting]
Check if the problem is solved.

ADO 1787136, Workpapers CS automation Add-In stays inactive