Hello VE3OAT, There are quite a lot of calculations in the file, until recently I had no problems ~4-5 seconds, then bit by bit it slowed down incredibly slow.
I am using Calc to log daily weather. Lowest Temp. Highest Temp. Rain. This is logged daily.
At the end of each month I sum the rainfall for that month. I get the lowest temp for the month, I get the highest temp for the month.
E.G. =sum(A1:A30) =min(B1:B30) =max(C1:C30)
I do this for each month. Then at the end of each year I put a table of each months high, low, rain. Then a bar graph of the table.
As stated earlier this didn’t cause any problem until recently.
I wondered if the thing had too many years, I divided the sheet into 2 year sections and saved them as 2017 - 2018. Etc.
Hope this throws some light onto the problem.
Regards,
Rod… VK3KBR