Kace reporting export to Excel error
Kace (Excel) Friday, 28 June 2024 by paul

When exporting a Kace report to Excel it displays the error below:

Error Running Report

Worksheet!X9999 -> Formula Error: An unexpected error occurred

This occurs if the field it is reporting on contains data which starts with a "=" character. This is interpreted by Excel as a formula and if the following data does not contain a valid formula then the error message is displayed.

This can be prevented by editing the data to change the first character from a "=" to another character.


Add Comment
No Comments.