SpreadSheet Takes Forever to Open

[blu99]

I've been using the program for several years and lately it can take up to 5 minutes to open up a saved Spreadsheet. I only have about 200 lines with 6 columns. Nothing fancy and opened up quick all these times and then suddenly slow as can be! I'm using 4.1.5 and even went back to an older version but it didn't make a difference.

Any ideas I would greatly appreciate it!

[RoryOF]

Check /Edit /Links to see if there are internet links you don't know about.

[John_Ha]

A bad Windows 10 update was reported to cause problems like this.

Upload the file for it to analysed.

[blu99]

How do I upload the file John?

Am waiting for it to open now to check the LINKS

[jrkrideau]

How to upload a file

[John_Ha]

Use the Upload attachment tab below where you type (128 kB max) or use a file share site, Dropbox or Google Drive for a larger file.

[blu99]

John,

I don't want to upload the file because it's a spreadsheet with my sales on a certain website, costs, fees, etc.

Guess I'll just have to put up with it taking forever to open up.

[robleyd]

The link How to upload a file jkrideau provided above also contains information on how to anonymise your document if it contains confidential information.

[John_Ha]

You can obscure the contents without affecting the structure too much (lines will spill differently because different characters have different widths) by changing every alphabetic character to an " x " with

Edit > Find and Replace
Tick Regular expressions (under More ...)
Find box [:alpha:]
Replace box x
click Replace all

Now type random values in the cells if you are paranoid about security ...

[karlespy]

This may or may not help but when I ran into this problem I found that for some reason my spreadsheet data/formulas had extended to a maximum row in the millions. I discovered this by pressing Cntrl-End and found myself at a location far beyond any actual data I had entered. Note: I had formulas that were invisible unless certain evaluation criteria were met so there was not a visual cue to the fact that these formulas had somehow been extended far beyond the originally set limits.

So... try pressing Ctrl-End and see when you end up. If it takes you to a location off the charts of what you expect then look for the offending rows/columns and do a bulk delete of the offending data/formulas... and be prepared to wait a while while the deletion takes place and completes. In my case, these were spreadsheets originally created in Excel then loaded into either OpenOffice or Libre Office and then saved as ods files. The load times for the original Excel formatted files remained fine, but the ods file loads extended up to 5 minutes for very small spreadsheets, albeit with multiple graphs which I had wrongly assumed to somehow be the culprit.

Hope this helps someone