Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Handling Large Data Files (Excel97/2000)

    I have a file with a large amount of data in a table in Excel ( Rows 30000 Columns 20.)

    I need to autofilter the table and then use that selected data.

    At the moment I am waiting approx 2-3 minutes for it to open and perform calculations. I am not allowed to use access.

    Are there a way of accessing the data in excel without activating all the "bells and wissles". Msquery tend to "hang" as soon as it is run.

    Thanks

    Mario

  2. #2
    New Lounger
    Join Date
    Nov 2001
    Location
    London
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Handling Large Data Files (Excel97/2000)

    Try turning Calculation off through Tools/Options select the Calculation tab & click on Manual.

    Don't forget to undo this when you are finished as new formulas will not calculate until you tell it to

    AjUK

Posting Permissions

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