How do I keep excel from downloading pictures when I copy and paste? It is slowing me down tremendously. Is there a way to set excel to not download pictures?
migrated from stackoverflow.com Dec 18 '10 at 16:57
This question came from our site for professional and enthusiast programmers.
Are you sure you mean "downloading"? When you paste something into Excel, and it includes pictures, they come from a temporary folder on your PC. But that takes ages, I know. If you only need text and numbers in your table, you can do this: in Excel, click on the little arrow next to the Paste button, select "paste special", and pick "Text". That way, only plain letters and numbers will be pasted into your cells: no formatting, no pictures, no links. It will be nearly instant. At least this is the way it works in my version of Excel. I don't think there is anything else you could do.
Edit: as an Autohotkey script:
After SendInput comes what would need to type by hand if you wanted to do the same by hand. I type alt+e ("!e"), then s, then press the down arrow, then press enter. Change it according as your version of Excel needs different key presses. The hotkey that triggers it all I set to alt+control+V ("!^v"), but you can change that.