How to change a large .xlsx into a .ods

[Trixy]

How to switch from Excel to LibreOffice Calc.
Just opening a .xlsx with LibreOffice Calc fails, especially for large documents. So this is the workaround:

1. Make and open a new Calc and name it fe TestImportExcel.ods .
2. File>Open> Choose your large Excel document
3. Wait, wait and wait,… just don’t do anything on your computer until it’s done. Don’t panic, don’t stop the process, maybe it takes an hour or more, but it will open.
4. Save to TestImportExcel.ods (or any other name)
   That’s it, so the tric is, wait long enough just give your computer the time, leave your computer alone, don’t disturb your computer. It also works with .xlsm . The VBA macro’s wil be imported, but the VBAmacro’s will not work in LibreOffice Calc.

[fpy]

@Trixy

fails, especially for large documents

any example ? order of magnitude ?

@Trixy

just give your computer the time

better monitor your CPU and RAM to prevent an infinite wait

@Trixy

(or any other name)

huh?! what was the “tric” with pt 1 ??

@Trixy

VBAmacro’s will not work

so, I guess, next “tric” is : Option VBASupport Statement