I’m trying to open a largish spreadsheet, in either .xls or .ods, but the loading goes about 90% then hangs up, and I have to force quit. Mac 10.15.7, LO 24.2.3.2. Is there some format thing I need to avoid in the spreadsheet? (It is mostly text and dates.)
like what-ish ?
a “known” problem is to format (often inadvertently) thousands of empty cells, which may lead to Mb files.
try to copy/paste your actual data in a new file to see if it gets small-ish-er.
Ah, thank you so much! I’ll check on that (with another computer that can use excel).
The .xls version shows it is 7.2 MB and the .ods as 1.3 MB.
Clare
Yes!
It opens readily now!
Clare