Hi all,
This had me scratching my head: at work, we're using a large-ish .xlsx file, with about 20K rows, with a lot of look-ups and so on. A messy job, but it's being kept in use due to, well, user reluctance to switch to an Access solution. You know the drill.
There is a manual operation where cells from one tab are copied and then Paste/Special/Values into another tab of the same workbook. There are three columns and about 20 thousand rows involved.
Until recently, we were using Excel 2007 and, on a stock PC, it took about 10-15 seconds for the paste operation to complete. Automatic recalculation is turned off, as there is a LOT of VLOOKUPs -- about 25 columns times 20 thousand rows.
Anyway, since our company upgraded to Excel 2010, the same paste operation now takes anywhere between 40 and 60 MINUTES. Automatic calculation is still turned off. I have no clue why is this happening. The same file, on a slower machine (2-year old HP Mini) under Excel 2007, performs the same operation in about 10 seconds.
Any clues? I am truly lost for ideas.
Cheers!
This had me scratching my head: at work, we're using a large-ish .xlsx file, with about 20K rows, with a lot of look-ups and so on. A messy job, but it's being kept in use due to, well, user reluctance to switch to an Access solution. You know the drill.
There is a manual operation where cells from one tab are copied and then Paste/Special/Values into another tab of the same workbook. There are three columns and about 20 thousand rows involved.
Until recently, we were using Excel 2007 and, on a stock PC, it took about 10-15 seconds for the paste operation to complete. Automatic recalculation is turned off, as there is a LOT of VLOOKUPs -- about 25 columns times 20 thousand rows.
Anyway, since our company upgraded to Excel 2010, the same paste operation now takes anywhere between 40 and 60 MINUTES. Automatic calculation is still turned off. I have no clue why is this happening. The same file, on a slower machine (2-year old HP Mini) under Excel 2007, performs the same operation in about 10 seconds.
Any clues? I am truly lost for ideas.
Cheers!
