Forum Discussion

EconomyOfScale's avatar
EconomyOfScale
New Contributor
3 months ago

Unusable ".txt" file after clicking "Export to Excel"

Hi OneStream Community,

During a UAT phase, one of our client’s users encountered an unusual error. When this user attempts to export either a CubeView or Dashboard using the "Export to Excel" button, a text file is generated instead of the expected Excel (.xlsx) file (see attached image). This text file is unusable.

Interestingly, this issue only affects this particular user, while all other users are able to export successfully to .xlsx without any problems.

As a temporary workaround, we’ve had the user export through the "Report" functionality, which provides the correct .xlsx output. However, this is not a sustainable long-term solution.

Has anyone experienced a similar issue or know the root cause and how to resolve it?

Thank you in advance for your support!

 

  • Ioana's avatar
    Ioana
    New Contributor III

    Hi,

    I am not familiar with this type of behavior, but it may be a file association issue: The user's system might incorrectly associate .xlsx files with a text editor or other non-Excel application. Check the default file association for .xlsx files on the user's machine. Ensure Excel is selected to be always used when opening .xlsx.

    Other causes may include group policies and restrictions made by the IT dept., but it may not be the case as other users can open it. Check also if Excel is properly installed and not missing any components.

    It seems more of a user's local environment or system configuration problem. Consider opening a ticket with OneStream Support, stating some context / share screens, including the IT team from the client as well.

    Thanks

    Ioana