Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Philadelphia, Pennsylvania
    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
    Thanked 31 Times in 31 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