What to do when WebHits reports give an error of "Invalid variant operation."

What to do when WebHits reports give an error of "Invalid variant operation."

book

Article ID: KB0084285

calendar_today

Updated On:

Products Versions
TIBCO Nimbus All versions

Description

Generating a WebHit report and choosing to save the file as a Excel spreadsheet an error window pops open saying  "Invalid variant operation."  The attached file has a screen shot of the error.

This is caused by not having Excel installed on the Nimbus server.

Issue/Introduction

Trying to save the WebHits report as Excel (XLS file) spreadsheet fails because Excel is not installed.

Environment

Windows

Resolution

Either install Excel or save the file as a .csv report.