Exported File Hangs Excel

I am working on a complex set of sheets and I need to compare the data in two different versions. I have exported each of the two sheets multiple times and, as of this morning, any Excel version of an export hangs Excel when I try to open it.

I realize this may be an Excel-only issue, but Excel is otherwise working without a problem for me.

Where do I start my troubleshooting?

Best Answer

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    Hi @Steve Kopischke

    I'd recommend starting with testing it in Google Sheets, Apple Numbers, or similar and see if the problem is present there as well.

    How did it go?

    I hope that helps!

    Have a fantastic day & Happy New Year!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • I am able to successfully open the downloaded sheet in Google Sheets. When I attempt to open that resulting file in Excel (via File->Download->Excel in Google Sheets), Excel hangs.

  • Update: I noticed the last attempt to open the file hung Excel, and I got distracted by an incoming message. I forgot I had been trying to open the file from Google Sheets.

    The file eventually opened. Then I attempted to open the second file (still in my Downloads folder).

    That file opened immediately.

    Consequently, the problem is not that Excel permanently hangs (though it can appear to), it's just that it takes quite a long time for the file to open. Were the file large, that would not be a surprise. However, it's only 35K.