Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying large amounts of data (Excel 2000)

    I need to combine some files that have 137 cols and 2600 rows, a substantial array size, into one large spreadsheet. I want to anticipate that the clipboard might choke on that size array and ask if there might be some other efficient way to move this data into one spreadhseet. Other files could have more rows but the same number of columns. Is there any special approach to these? Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying large amounts of data (Excel 2000)

    It probably depends on the amount of memory you have and on the complexity of the formulas in the ranges to be copied. I have seldom encountered problems with copying large ranges (even larger than the one you mention.)

Posting Permissions

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