Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

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

Your Answer


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.