Hi,
My LibreOffice Calc 6.2.8.2 is loading painfully slowly. The progress bar gets to about 90% & hangs there for a minute. The progress bar then disappears & I’m left with a blank screen. If I click on the blank screen, Calc eventually opens. I just updated to 6.2.8.2 because it had just started doing the same thing in the previous version. It also saves very slowly & had been doing the same in the previous version. The Calc file I’m trying to open is 208 KB & is an ODS file. My original file was built in Excel. I opened it with LibreOffice Calc when I switched from Excel to Calc 6 months ago & now it’s an ODS file. I resave the file with a new name every month, as I need to keep a running tally of certain things on the spreadsheet. I’ve been running Calc on a Windows 10 PC with no issues, other than the slow saving, since I started using LibreOffice. The slow loading only occurs with Calc, not Writer, & only with that particular Calc file. I can open other Calc ODS files quickly. Any idea how to fix this?
More information:
*The Calc file I’m having trouble with is a workbook containing 11 sheets.
*Several of the sheets contain cells linked to cells on other sheets within the same workbook.
*I tried opening a new/empty Calc workbook, added in 11 new sheets, & copy/pasted the data from my problem Calc workbook, to the new one.
- I adjusted the formulas to refer to cells within this workbook, because they were now referring to that cell in the old problem workbook.
*I did 1 sheet at a time, then saved the workbook after each new sheet addition. It saved VERY quickly.
*I had no slow saving or opening of this file UNTIL I added a sheet that contains a LOT of comments. As soon as I added that heavily commented sheet, the saving speed slowed immensely. I also experienced the slow opening, hanging up at 90% open, followed by the blank screen that I was experiencing with the original workbook.
*I made a copy of the file & tried deleting different sheets & the problem disappears when the commented sheet is removed & reappears when it’s added back in.
*Other sheets have comments AND links & don’t cause the problem as long as THAT 1 sheet is removed. YES, the comments are necessary.
Some more information:
*The heavily commented sheet is definitely causing the slow saving & slow opening, then hanging up problem. There are no circular references.
*I tried deleting all the comments, saved the workbook, and it was still slow.
*I closed the workbook & tried reopening it without the comments on that 1 sheet. The slow opening followed by hanging up still occurred.
*I then also tried deleting the 2 formulas on that page, which left nothing but a list of data on the sheet, resaved (still slow), closed the workbook, reopened it, & experienced the same slow open & hang up.
*I deleted the sheet, saved (very fast save), closed the workbook, & reopened it quickly & without any problems.
*I also tried the suggested answer below.
*I opened a fresh workbook & inserted sheets from the original problem workbook as suggested below. I saved the new workbook & tried to reopen it. I experienced the slow open & hang up with the new workbook too.
*There was also a warning across the top of the new workbook sheets: “Automatic update of external links has been disabled.” There is an “enable content” button to click on the warning. I clicked that link & a progress bar appeared at the bottom of the page that said “updating external links.” The name of my workbook, at the top of the screen, was immediately followed by (not responding), which eventually disappeared when the update progress bar disappeared.
*I closed the new workbook, reopened it, & experienced the same slow open, followed by hang up, & blank screen as the original. However, when the new workbook opens, I always receive the warning across the top of the new workbook sheets: “Automatic update of external links has been disabled.” This is not an improvement!
I can not figure out why that sheet is causing problems now, when it has been in that workbook for over a year.