Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Open a big file

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to open a file automatically but this file is bigger then Microsoft Excel allows.
    How I can seperate it into two sheets automatically?
    Thanks

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    what type of file is it that you are trying to open?

    Ed

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Any update on te file discription mate?


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm interested in the part about:

    "bigger then Microsoft Excel allows"

    I believe the size of a workbook is limited only by the available memory on a given PC. Perhaps your available memory is hurting. Try cleaning up your PC:

    http://www.thewordexpert.com/cleanyourpc.htm

    If that doesn't help, try getting the file to a machine that has more RAM.

    Hope this helps!
    ~Anne Troy

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Depending on what you are trying to do for example a Pivot Table for data analysis. You can imported to MS Access and then link to it from Excel.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    sorry just been thinking is this an excel file or some imported file .. poss odbc link?




    _________________
    If you can help a guy in trouble -
    If you can sort that nagging problem -
    Pease try, at home, at work or on a message board.

    Others help you!
    So PLEASE help if you can - If only the once.

    Thank you -

    Rdgs
    ======

    [ This Message was edited by: Jack in the UK on 2002-05-01 12:08 ]

  7. #7
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Jack: I have never removed your posts. I do not have that capability. Also, perhaps the asker does not have enough space on his hard drive to create the temporary file necessary to open his document. Cleaning up his hard drive may resolve the problem.

    _________________
    TheWordExpert

    [ This Message was edited by: Dreamboat on 2002-04-27 11:03 ]

  8. #8
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hello there

    I think the first poster means that the file
    he wants to import is more than 65535 rows
    and excel can't handdle them.
    I suggest to break that file with an editor
    in two or three and then import in excel



  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi --

    sounds like you could have excel file greater that 65536 rows deep can you split this data into two sheets>


    _________________
    If you can help a guy in trouble -
    If you can sort that nagging problem -
    Pease try, at home, at work or on a message board.

    Others help you!
    So PLEASE help if you can - If only the once.

    Thank you -

    Rdgs
    ======

    [ This Message was edited by: Jack in the UK on 2002-05-01 12:07 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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