I want to copy / paste specialtranspose rows of numerical data from one
excel workbook to another.

Nearly every time I right click on the destination worksheet instead of
giving me the "paste special" menu to select "transpose" it gives me a
selection box asking me to select a format.

I tried adding a paste special button to the toolbar, but it still brings up
the same object menu.

My colleague does not have this problem so I'm guessing it's to do with my
set up.
It is the same in excel 2003 & 2007
Can anyone suggest how to fix this problem?

Thank-you.