Ask Your Question
0

How do I open large (400 MB) .xls file in Calc?

asked 2015-07-18 14:28:03 +0100

RIchard gravatar image

Hello guys,

Calc just freezes in about 3/4ths of the loading bar. I tried everything (cutting the file: some slicers don't work, others require Excel to work; converting to .ods: it is apparently too big for the online converters, and haven't found any offline converter). How should I open that file?

edit retag flag offensive close merge delete

Comments

You can file a bug, if your file content is not sensitive? This would allow developers to investigate the problem. What content is inside this Excel file? (graphs, conditional formatting, advanced formulas ...) Is it XLS or XLSX? (try both).

Ljiljan gravatar imageLjiljan ( 2015-07-19 08:01:15 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2016-07-03 09:06:24 +0100

paulparker gravatar image

Similar issue for some time, finding some files like two xls here fail to open, so fail to convert to ods

   1885287 Jul  3 15:16 CCisda20160701.xls    
   1351562 Jul  3 15:16 DDmoda20160701.xls

[ Source http://www.afr.com/share-tables BTW self renames to show dates]

For reference the CSV version files open OK, then convert.

 109703 Jul  3 15:15 CCisda20160701.csv
  69316 Jul  3 15:15 DDmoda20160701.csv

Noted earlier EU sort ability to convert XLS to ODS, so hoped this would be resolved.

IMHO is enough discourage some from change to ODS.

.

edit flag offensive delete link more
-1

answered 2015-07-30 03:50:41 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Try to reduce the size of your file (check if all macros and colourations are necessary) try to transfer the content in a new Excel document (sometimes you can have an important weight gain). Good luck

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2015-07-18 14:28:03 +0100

Seen: 1,478 times

Last updated: Jul 03 '16