Cut - Special paste - Transpose ?

Hi Guys,

I need a work around as it seems you can not cut - special paste - transpose. You can only Copy - special paste - transpose!

The problem is that I have a very big very integrated spreadsheet with formulas and functions that i need to transpose. When I copy and paste the formulas etc. remain linked to the original sheet and don't link correctly in the new sheet resulting in #REF! Also too many formulas / functions to individually make values absolute although a lot of them already are?

Please help!

Regards

Jacques