When exporting HandiSoft reports to Excel the error: 'Call was rejected by Callee' can occur. Try restarting Microsoft Excel and try again.
The common reasons for this occurring:
Default number of sheets
Add-ins
Anti-Virus
Using an incorrect version of MS Office
Change the default number of sheets in Microsoft Excel
By default, new spreadsheets created in Excel contain one worksheet. The HandiSoft applications typically need 3 worksheets when exporting data.
Open Microsoft Excel.
Click the File tab, then click Options.
Ensure the General screen is active on the Excel Options dialogue box.
Go to the When creating new workbooks section, and enter the number of worksheets, (three or more) in the Include this many sheets box. You can also click the up and down arrows on the box to increase or decrease the number.
Click OK to save the change and close the Excel Options dialogue box.
When you create a new workbook, it will have the number of worksheets you specified.
If you use HandiSoft Online (on Access Evo), and the error still occurs after updating the number of sheets, raise a new case. Include the user's full name and email address. An analyst will advise you further. The additional suggestions below will not apply to HandiSoft Online users.
Add-ins
To test if your add-ins are causing this error, you can inactivate the Excel and COM add-in.
To inactivate an Excel add-in
Open Microsoft Excel.
Click the File tab, Options, Add-Ins category.
In the Manage box, click Excel Add-ins, Go.
In the Add-Ins available box, clear the check box next to the add-in you want to inactivate, and then click OK.
In many cases, when you inactivate an add-in, it is removed from its group on the ribbon. In other cases, to remove the add-in from the ribbon, you may need to restart Microsoft Excel.
To inactivate a COM add-in
Open Microsoft Excel.
Click the File tab, Options, Add-Ins category.
In the Manage box, click COM Add-ins, Go.
In the Add-Ins available box, clear the check box next to the add-in that you want to inactivate, and then click OK.
In many cases, when you inactivate an add-in, it is removed from its group on the ribbon. In other cases, to remove the add-in from the ribbon, you may need to restart Microsoft Excel.
Inactivating an add-in does not remove the add-in from your computer. To remove the add-in from your computer, you must uninstall it. Refer to your IT for assistance.
Anti-Virus
Try to disable or temporarily pause your Anti-virus then attempt the report export again. You may need to refer to your IT or Anti-virus software provider.
Microsoft Office version
Ensure that you are using the full version of MS Office and not the Microsoft Office desktop apps version of Microsoft Office.
Microsoft Office desktop apps is a cut-down version that is pre-installed on Windows 10 computers. This version is not compatible with HandiSoft.
How to check the version of Microsoft Office
Start Microsoft Word or any other Office app and look at the starting screen.
Quickly review this screen, as it is only displayed for a second or two. It will display he name and version of the app that you are using.