Copy/Paste from web, but don't include drop down boxes and other form components

[Chasden]

Hello,
I've just changed offices, so I'm using a different computer. I've imported all of my Office settings and macros, but there is one setting that I can't figure out.

There are several tables on a website with raw data that I copy and paste into an Excel workbook daily. These tables have a drop down box in the last column of each row. On my old computer, the drop down boxes would not paste into the spreadsheet (only the data would). This was fine.

On my new computer, the drop down boxes paste into the form, which is annoying. I could go to Design Mode and delete them all, but I'd have to do this to over 100 of them every day. I could also just leave them there, but then they will slowly increase the size of the file with unnecessary data (plus it's sloppy).

I don't know what I did on my old computer to cause Excel to not paste drop down boxes, but I want that setting back. How do I get it?

Thank you.

 

[Truiz]

Have you tried Paste Special - Paste Text Only option?

 

[Chasden]

Having to go to the ribbon to use Paste Special this many times per day is a productivity nightmare. Fortunately, I have a macro for it, but using it for this job gives an error. Hitting debug just highlights the PasteSpecial command itself.

So far my solution has been to go back to my old office to get these reports done, then return to the new office when I'm finished. I still have no idea what's different about the old office computer.

 

[Truiz]

Was this issue resolved?

 

[Chasden]

What I did eventually was just deal with the drop down boxes, let them pile on top of each other, and then at the end of the job, I'd go into Design Mode, use the selection tool, drag across the entire spreadsheet, and delete all the boxes.