I have a specific calc file that is slow to open, and I always get a not responding message before it finally loads. This happens if I load it in safe mode and with acceleration and OpenCL turned off. I do not have any problems with other calc sheets. How can I trouble shoot to find if there is something inside the sheet causing this problem?
One reason can be a not availabe resource from network or internet. Then calc may wait until some timeout is reached.
.
You could check, wich printer shows, if you select print. Another point is connections to external data (maybe copied from the internet). Navigator is usually a good start…
Not sure what you mean navigator is a good start.
It is only one calc file I am having problem with as all other calc files open fast. I have set the printer to print PDF with no solution. This is a file on my local computer. I am not on a network, and I am not accessing the internet in this file. I even tried copying all the tabs and pasting into a new calc document with no solution. I was not having this problem with this file until recently so it may be something I did but I have no clue what to look at.
I do not want to upload this file as I have financial data in the file. I will next try saving the file under a new name, open that file, and delete one tab at a time and see if I can determine what tab to find the problem. I can still use this file, it is just annoying. I have all the Libre updates and all the Windows updates. I checked most of the drivers to see if updates are needed to no avail.
I figured out the problem and will post that here in case anyone else has this problem.
In the problem document, I saved it as test and then deleted the main tab, saved the document, the loaded the document and it loaded fast again. I looked at the original document and saw one small column I use for spacing that is filled with light yellow went to the end of the document. I cleared the formatting in that column, put the color in that column just down to the rows I needed, saved it again, and then opened the document. It loads fast again! I had no idea the column was filled with yellow to the end of the document which would make that load slowly. I will mark this as solved.