Ask Your Question
0

Spreadsheet will no longer load in LO Calc [closed]

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

libdrone100 gravatar image

updated 2020-08-04 18:12:59 +0100

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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-04 18:13:17.052150

1 Answer

Sort by » oldest newest most voted
0

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

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

Question Tools

1 follower

Stats

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

Seen: 80 times

Last updated: Mar 27 '17