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.