exporting excel spreadsheet with hidden columns into word

[seaggie1]

I have an excel spread sheet that has columns that are not used hidden, they will be used in later editions of the spreadsheet, that I am importing into word. To do this I copy the spreadsheet area that I need then I paste it into word. When the spreadsheet gets into word the columns that were hidden in excel are now unhidden in word. I have the worksheet locked to editing also but that does not seem to help. Here is something else that is wierd. I also have rows that are hidden that stay hidden in word?

 

[Jim North]

Hello seaggie,

I've been playing with it, and it seems if you do a pastespecial in Word... NOT using the HTML version, it works ok. Give it a try.