Office app capable of opening a big spreadsheet?

Keith Dalby

New member
Mar 29, 2013
3
0
0
Hello.

This is my first post here. I apologise if this question has been asked elsewhere. I have a spreadsheet that is in excess of 3MB in size. It contains a lot of index and match formulae. I have tried to use Kingsoft Office and OliveOffice Premium to use the file but with both apps I am only able to view the spreadsheet. When I try to edit the spreadsheet using Kingsoft office, I am told it is too large. When I try to edit the spreadsheet using OliveOffice Premium, the app simply crashes (if that is the correct word for a sudden app closure). Even Google Docs complains about the number of 'complex formulae' (to paraphrase their words) when I try to convert it to that format.

I am prepared to pay for an app, but I'm wary of paying the equivalent of $15 for an app that may or may not work for my purposes. The spreadsheet contains no non-standard excel formulae, no formatting, no macros and no array formulae. I have systematically erased all empty cells of data and formatting (just in case) in an attempt to make the file smaller. I have followed all of the suggestions I have been able to find to reduce the file size but, alas, the spreadsheet simply will not be edited in either of these two apps. The only thing that I think could be causing the difficulty is the sheer number of nested index and match formulae, but these are unavoidable. Unfortunately I cannot attach the file here because it does contain sensitive information, however I could strip the spreadsheet of that information if it would be helpful.

My question: is there an office app that would open and allow me to edit such a file? If not, is there an alternative way of using my spreadsheet on my Nexus 7 tablet without having to resort to running a remote desktop?

Many thanks in advance

-Keith
 
Not sure whether there is but suggest you look at Office Suite. The Viewer is free and there is a trial version free to allow some testing.

From my N7 or BBPB or HPTP or HP Laptop
 
In my experience all of the office apps/suites are really clunky with spreadsheets. I've be even developing a spreadsheet to be shared by our group and I've had to be very careful what formulas I used. Forget about macros or advanced scripts.
 
How about DocToGo? That is what I use.

Sent from my Nexus 7 using Android Central Forums
 
Don't know for sure on that size but OfficeSuite Pro has not had any problems for me with Excel. Imports .rtf files too (some don't).