Welcome to iPadForums.net Guest - Click Here to Register

.xls file issue

This is a discussion on .xls file issue within the iWork Forum forums, part of the iPad App Store category; 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 ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Results 1 to 9 of 9

Thread: .xls file issue

  1. #1
    iPad Fan!
    Member #
    71510
    Join Date
    Jun 2011
    Location
    israel
    Posts
    6

    .xls file issue

    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. Ads


  3. #2
    iPF Legend
    Member #
    28530
    Liked
    1518 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,429
    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.

  4. #3
    iPad Fan!
    Member #
    71510
    Join Date
    Jun 2011
    Location
    israel
    Posts
    6

    thank you for your comment but

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

  5. #4
    iPF Novice
    Member #
    62766
    Liked
    2 times
    Join Date
    Jun 2011
    Location
    Washington state
    Posts
    79
    Can you possibly split the spreadsheet onto several sheets and just export the part you need to work on to the iPad?
    Beyond here, there be dragons.

  6. #5
    iPad Fan!
    Member #
    71510
    Join Date
    Jun 2011
    Location
    israel
    Posts
    6
    Quote Originally Posted by Bimjo View Post
    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?

  7. #6
    iPF Novice
    Member #
    62766
    Liked
    2 times
    Join Date
    Jun 2011
    Location
    Washington state
    Posts
    79
    Quote Originally Posted by edig85 View Post
    Quote Originally Posted by Bimjo View Post
    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]
    Beyond here, there be dragons.

  8. #7
    iPad Fan!
    Member #
    71510
    Join Date
    Jun 2011
    Location
    israel
    Posts
    6
    Quote Originally Posted by Bimjo View Post
    Quote Originally Posted by edig85 View Post
    Quote Originally Posted by Bimjo View Post
    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

  9. #8
    iPF Legend
    Member #
    27654
    Liked
    119 times
    Join Date
    Jan 2011
    Location
    Scotland
    Posts
    15,248
    Quote Originally Posted by edig85 View Post
    Quote Originally Posted by Bimjo View Post
    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

  10. #9
    iPF Novice
    Member #
    35762
    Liked
    1 times
    Join Date
    Feb 2011
    Location
    Aviano, North Italy
    Posts
    32
    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


Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. Replies: 7
    Last Post: 08-10-2012, 06:10 AM
  2. File Sharing, not file transfer
    By Terryfic in forum iPad Help
    Replies: 3
    Last Post: 05-10-2011, 10:25 AM
  3. Choose file issue
    By Dirtymind in forum iPad Help
    Replies: 6
    Last Post: 10-15-2010, 06:07 AM
  4. .pdf file issue
    By thehatguy in forum iPad Help
    Replies: 3
    Last Post: 09-29-2010, 04:50 PM
  5. play MP4 file under 'File'
    By adsl3w5h in forum iPad General Discussions
    Replies: 0
    Last Post: 09-15-2010, 09:02 PM

Search tags for this page

how to open xls files on ipad

,
how to open xlsb file on ipad
,
open xlsb file ipad
,

open xlsb file on ipad

,

open xlsb ipad

,

open xlsb on ipad

,
xls on ipad
,

xlsb on ipad

Click on a term to search for related topics.