Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

One of my colleagues is having a trouble when copying data from our website to Excel. Excel freezes for 5-7 minutes (we timed it) before any data shows up. If using Paste Special / Values it's instant, but when doing a normal formatted paste it takes forever. Any ideas on how to solve this?

WinXP with Office 2007 Standard SP3

share|improve this question
1  
Sounds like it's trying to copy the formatting of what you've copied. I'd suggest to continue to copy - paste special values. You could write a macro for this and assign it a shortcut key –  Raystafarian Mar 29 '12 at 15:17
add comment

1 Answer

If you are okay with losing some formatting, you may want to try pasting to notepad first. then cut the data from notepad and paste that into Excel.

share|improve this answer
    
Problem is that end users can forget to do the special paste. If special paste can be set to be the default operation this wouldn't be a problem. –  Simon Fredriksson Mar 30 '12 at 9:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.