LibreOffice Calc 6.2.8.2 is loading VERY slowly & hangs up
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 ...