Ask Your Question
0

Spreadsheet will no longer load in LO Calc

asked 2015-11-20 18:51:38 +0200

libdrone100 gravatar image

updated 2016-03-13 22:24:49 +0200

Alex Kemp gravatar image

Hi. I have been working with a large spreadsheet that was created in Excel. I have been saving it as an xlsx file. LO calc would often freeze and crash, but I was able to work my way through the editing process, saving often, albeit with significant delays. We are running LO on Windows machine. All of a sudden this spreadsheet will not load. I get a blank page and then the program says "not responding" and freezes. It doesn't even crash. I just get an interminable blank screen until I close the program manually.

I was able to open an earlier version of the file, but want the latest version - which can be viewed in some viewers, like google docs, but not past the first screen.

I sent this file to someone else who opened it in Excel without problem.

Is the entire file somehow locked in LibreOffice?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-03-27 14:17:27 +0200

JohnHa gravatar image

LO does not support everything in .xlsx (or .docx etc) files. Try this

1 Create an new, empty spreadsheet

2 Insert > Frim file. Navigate to the file and insert it

3 Now save it as a .ods

You should always work in, and save, all files as .odt, .ods etc, and never as .docx, .xlsx etc.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-11-20 18:51:38 +0200

Seen: 57 times

Last updated: Mar 27 '17