One way:

Select the range to copy
Edit|Replace
what: = (equal sign)
with: $$$$$
replace all

Now your formulas are all text.

With that range still selected
edit|copy
then select the new location
edit|paste special|transpose

Now select each range
edit|replace
what: $$$$$
with: =
replace all

And you've converted the text back to formulas.

(Don't forget to do both the original range and the pasted range.)

Bill wrote:

I have worksheet #2 containing a table where all cells, including row and
column headings, contain links to values in worksheet #1 in the workbook. I
want to "transpose" the table in #2 (including row and column headings) into
a table in worksheet #3, so that the rows in #2 become columns on #3 and the
columns in #2 become rows in #3, while maintaining the links to values in #1.
How do I do this.
I need a command functionally equivalent to
copy/paste special values/transpose/link
but in paste special values I can choose either transpose or link, but not
both.
Bill

--

Dave Peterson