.xls file issue

Discussion in 'iWork Forum' started by edig85, Jun 29, 2011.

  1. edig85
    Offline

    edig85 iPF Noob

    Joined:
    Jun 29, 2011
    Messages:
    6
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    israel
    Ratings:
    +0 / 0
    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?
  2. twerppoet
    Online

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,827
    Thanks Received:
    2,226
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,652 / 1
    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.
  3. edig85
    Offline

    edig85 iPF Noob

    Joined:
    Jun 29, 2011
    Messages:
    6
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    israel
    Ratings:
    +0 / 0
    thank you for your comment but

    my problem still has not solved, maybe anyone can think of something else?
  4. Bimjo
    Offline

    Bimjo iPF Novice

    Joined:
    Jun 5, 2011
    Messages:
    79
    Thanks Received:
    2
    Trophy Points:
    0
    Location:
    Washington state
    Ratings:
    +2 / 0
    Can you possibly split the spreadsheet onto several sheets and just export the part you need to work on to the iPad?
  5. edig85
    Offline

    edig85 iPF Noob

    Joined:
    Jun 29, 2011
    Messages:
    6
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    israel
    Ratings:
    +0 / 0
    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?
  6. Bimjo
    Offline

    Bimjo iPF Novice

    Joined:
    Jun 5, 2011
    Messages:
    79
    Thanks Received:
    2
    Trophy Points:
    0
    Location:
    Washington state
    Ratings:
    +2 / 0
    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]
  7. edig85
    Offline

    edig85 iPF Noob

    Joined:
    Jun 29, 2011
    Messages:
    6
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    israel
    Ratings:
    +0 / 0

    thank you for your comment, i'll try it and update
  8. Tim SPRACKLEN
    Offline

    Tim SPRACKLEN iPad Legend

    Joined:
    Jan 3, 2011
    Messages:
    15,246
    Thanks Received:
    121
    Trophy Points:
    0
    Location:
    Scotland
    Ratings:
    +121 / 0
    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
  9. gwynsoft
    Offline

    gwynsoft iPF Novice

    Joined:
    Feb 27, 2011
    Messages:
    32
    Thanks Received:
    1
    Trophy Points:
    0
    Location:
    Aviano, North Italy
    Ratings:
    +1 / 0
    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
Similar Threads
  1. Boysie
    Replies:
    3
    Views:
    31,611
  2. thehatguy
    Replies:
    3
    Views:
    2,548
  3. Dirtymind
    Replies:
    6
    Views:
    8,379
  4. eclauss
    Replies:
    1
    Views:
    853
  5. fagani
    Replies:
    1
    Views:
    573
Loading...

Share This Page

Search tags for this page
download xlsb file on ipad
,
excel files wont open o ipad
,

how to open xls files on ipad

,

how to open xlsb file on ipad

,
how+to+open+.xls+file+on ipad
,
ipad won't open xlsb
,
ipad xlsb
,
numbers on ipad issue with xlsx
,
open xlsb file in numbers
,
open xlsb file ipad
,

open xlsb file on ipad

,

open xlsb on ipad

,
problems opening xlsb in quick office
,
xls files won't open on ipad
,
xls ipad
,
xls ipad issue
,
xlsb file ipad
,
xlsb file wont open of ipad
,
xlsb for ios
,

xlsb on ipad