Ask Your Question

Large Calc file crashes when saving?

asked 2016-02-28 19:17:19 +0200

Vedaji95 gravatar image

updated 2016-03-07 21:35:24 +0200

Alex Kemp gravatar image

Just upgraded to LibreOffice 5.0..5.2. I have large Calc files with over 200 sheets per file. When I "save as" the file, it starts to save and then a Windows dialog appears stating that LibreOffice is not responding. This dialog box continues and then looks for a solution and, not finding a solution, then shuts the program down. On the previous LibreOffice versions, when I saved the file it would state that "LibreOffice" was not responding, but then it would complete saving the file normally. This is a real irritation since I cannot save my file when I make any changes. I would appreciate any suggestions you have. Thank you.

edit retag flag offensive close merge delete


Please try resetting the user profile, sometimes solves strange issues. Usually it's enough renaming/deleting the file "user/registrymodifications.xcu", it affects all the options in Menu/Tools/Options, and the files "user/basic/dialog.xlc" and "scrip.xlc" are overwritten, additionally custom colors in "user/config/standard.soc" are lost.

m.a.riosv gravatar imagem.a.riosv ( 2016-02-28 23:57:57 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-02-17 19:52:03 +0200

JohnHa gravatar image

updated 2017-02-17 19:53:34 +0200

Try this

1 File > New > Spreadsheet ..., and create an empty spreadsheet

2 Insert > From File ..., and navigate to the file which crashes and choose it

3 Save the resulting file.

Have a look - the new file is probably significantly smaller in size than the original file. Files edited many times seem to get "tangled" and this "un-tangles" them by removing redundant junk. The response time when you edit will probably be significantly improved.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-02-28 19:17:19 +0200

Seen: 862 times

Last updated: Feb 17 '17