Paste Special is extremely slow

S

Shaun

I have a spreadsheet with over 650000 rows. If I do a "Paste Special..." on
a column to convert from Formulas to Values it takes over 20 minutes! Anyone
know how can I speed it up? I'm surprised because it was so quick (< 5 secs)
to copy and paste the Formula over all the rows and see the results in the
column.

Thanks,
Shaun
 
J

Jim Rech

Excel 2007 obviously. I can't think of a reason the PV should be so slow
given the speed of the copy/paste. I just tried a PV of formulas in the
range A1:A650000 and it took just a split second. Little else in the sheet
of course. I guess I'd have to have an example sheet that manifests this to
investigate further.

--
Jim
|I have a spreadsheet with over 650000 rows. If I do a "Paste Special..."
on
| a column to convert from Formulas to Values it takes over 20 minutes!
Anyone
| know how can I speed it up? I'm surprised because it was so quick (< 5
secs)
| to copy and paste the Formula over all the rows and see the results in the
| column.
|
| Thanks,
| Shaun
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Special Values 2
Extremely slow processing 1
Linking w/Paste Special 1
Extremely slow recalculation time 7
Excel 2007 extremely slow to delete cells 1
Copy and paste special 2
Macro to Cut and paste Values 2
Paste Special Formula Multiply feature doesn't work anymore 1

Top