In my own experience, file sizes like this will cause some slowness, but load and save times should be similar to each other. I don’t think that size alone is the problem; there is some other cause at work in this case, although possibly magnified by the file size.
Let’s start with a likely explanation, in Excel if you click on a cell with a link you immediately follow the link, In Calc you need to Ctrl+Click. There is usually a tooltip to say this but if the spreadsheet is slow then you might not see it. You can change the behaviour of Calc, click Tools > Options > LibreOffice > Security and in the part headed Security Options and Warnings, click the Options button. In the dialogue box that opens untick the box Ctrl-click required to open hyperlinks
The spreadsheet slowness is the main issue. With 1200 hyperlinks, I wonder if the data isn’t better suited to a database.
Do you have any Database Ranges defined? Click Data > Define range and check that you haven’t selected to the the end of the sheet as this can cause severe slowness. Edit the ranges to reduce them to an expected extent.
You can see the description of the slowness issue in LibreOffice Calc (not responding) in Title Bar for several seconds after an unremarkable edit. If you do try opening the sample there you will see a similar delay on opening as in your description. Don’t try editing any of the cells in row 16, just redefine the range (Data > Define range) to something like $Sheet1.$A$16:$Z$16 (or even to AMJ, the older width limit) from $Sheet1.$A$16:$XFD$16 and save. Close and reopen that file and it will be instant instead of 10 or so seconds.
1 Like
I experience the same in a type of sheet, where i modify an entry set of data over 5 sheets of same size to create my result. As some formulas have VLOOKUPS or similiar functions to columns of size 2000 to 4000 rows. a tiny change in a referenced row needs a lot of columns to update. This can be seen at changing sheets directly after edit and obviously on (first) save. However subsequent saves are quicker.
.
On thing to consider: Referencing the whole column like A:A is widespread in Excel, but a decent range (2500 and 4000 in my case) is maybe quicker.
.
Bur as we know noting about your contents this is more or less idle talk…
EarnestAI - hello again
Spent all day chopping my life’s work in two, reducing the save time
to about 6 mins, which I could tolerate - just!
Hyperlinks - you’re probably right about databasing 1200 links.
Ctrl-click produces the curious error message " cannot be passed to an
external application to open it (e.g., it might not be an absolute
URL, or might denote no existing file). My picture files are in the
same folder as my .ods stuff; they are Faststone .jpgs, nothing
special. I DON’T understand the “Target in Document” box, so ignore
it!
Ranges - I learnt on Excel to minimize these, where it can cause similar havoc.
Thanks once more