.xls file issue

[edig85]

Hello everyone.
i have a big .xls file that i'm editing frequently in numbers.
the problem is(in my opinion) the that file weighs too much and everytime that i change something the ipad freezes for a few seconds. i want to know is there something i can do fo fix it? because it's impossible to work this way. maybe saving it in another format which works better with numbers? any ideas?

 

[twerppoet]

Changing the format won't do anything. Like any program, Numbers only works in it's native format. It only imports and export the .xls files. Internally they are the same no matter what format it says when you save it.

The only thing I can suggest is to make sure you have as much free RAM as possible. Double tap on the Home button. When the multitask bar pops up dap an hold on an icon until it jiggles, then tap the minus sign to close it. This frees up any RAM that the app may have been using.

iOS keeps several recent apps in RAM, ready to start running again from where you left off. Some may even have a background task going, tho those should be limited to finishing a download, playing music, or updating locations (for map and tracking apps). Normally this is a convenience, allowing you to switch back and forth between apps quickly, however if you need maximum performance from the iPad closing them may help.

The list itself can be very long, since it will list pretty much every app you've used since the last time you cleared it. On an iPad 1, only the first 4 to 6 apps listed are normally still in RAM. I've seen as many as 18 still using RAM on the iPad 2.

There probably are ways to clean up a spreadsheet to make it run more efficiently, but I've little idea how to do this. Minimizing the number and complexity of formulas comes to mind, but I'm sure that would be a pain. If some of the worksheets are unrelated to the others (not needing to share data or be together for easy data entry) you could break the spreadsheet up into more than one document.

Try the clean up first, and if that does it, good. If not consider how you might be able to reorganize the spread sheet into separate documents that would still be easy to work with. Last resort would be recreating the spreadsheet with simpler and few formulas, if possible.

Also, one of the other Office style apps may handle the spreadsheet faster. Documents to go and QuickOffice are two of the most popular. Here is a good summary by richsadams that might give you and idea of what you might want to try.

 

[edig85]

thank you for your comment but

my problem still has not solved, maybe anyone can think of something else?

 

[Bimjo]

Can you possibly split the spreadsheet onto several sheets and just export the part you need to work on to the iPad?

 

[edig85]

Can you possibly split the spreadsheet onto several sheets and just export the part you need to work on to the iPad?

unfortunately that's impossible, i thought that xls files is native excell files and maybe numbers has his own native file that works best on apple soft, am i wrong? because i dont mind working with this file only on the ipad?

 

[Bimjo]

Can you possibly split the spreadsheet onto several sheets and just export the part you need to work on to the iPad?

unfortunately that's impossible, i thought that xls files is native excell files and maybe numbers has his own native file that works best on apple soft, am i wrong? because i dont mind working with this file only on the ipad?

If the file is just really big it may make no difference which program format the file is actually in. How big is the file?

The only way to find out is probably to use numbers on a Mac to open/save in numbers format and move the numbers file to the iPad and try it. [shrug]

 

[edig85]

Can you possibly split the spreadsheet onto several sheets and just export the part you need to work on to the iPad?

unfortunately that's impossible, i thought that xls files is native excell files and maybe numbers has his own native file that works best on apple soft, am i wrong? because i dont mind working with this file only on the ipad?

If the file is just really big it may make no difference which program format the file is actually in. How big is the file?

The only way to find out is probably to use numbers on a Mac to open/save in numbers format and move the numbers file to the iPad and try it. [shrug]

thank you for your comment, i'll try it and update

 

[Tim SPRACKLEN]

Can you possibly split the spreadsheet onto several sheets and just export the part you need to work on to the iPad?

unfortunately that's impossible, i thought that xls files is native excell files and maybe numbers has his own native file that works best on apple soft, am i wrong? because i dont mind working with this file only on the ipad?

As the poet said in his post, it doesn't make any difference what format the file is in because, before Numbers starts to work on it, it converts it to its own internal format irrespective of the original format it was in. Once it's converted it, it then operates on the file in that internal format, until it's time to save the file for the user, when it converts it back into whatever format the user chooses. But whether you import it in .xls, .xlsx or numbers won't make any difference to how the file is processed once it's in Numbers.

Tim

 

[gwynsoft]

Hi edig85

I don't yet have enough posts to pm you direct, but if you want to privately send me a copy of your xls, I will see what I can do to make it faster on ipad since I happen to have all the necessary software and devices.
Cheers