Excuse me, I have some problems using .xls files on LibreOffice Calc. I tried opening the file and it worked but when I tried to save my work, it crashed. Is there any way to make it work?

It worked on Microsoft Excel on Windows 11. The file crashed the computer, but it worked passed 5 minutes and I could save my work.

  • Cora@lemmy.worldEnglish
    1·
    1 year ago

    Damn, a 1.5GB Excel file!? That sounds like a nightmare to work with. And here I thought a 200MB Excel file acting as a store’s entire yearly accounting ledger (where I used to work) was bad!

    At this point, you need a proper database and some reporting scripts / software. If that one file somehow gets corrupted, it’s all over.

  • empireOfLove@lemmy.oneEnglish
    1·
    1 year ago

    Yeah, you can make it work by finding one of your it guys and dumping it in a real database. Spreadsheet software is NOT meant to handle data like that.