I am trying to transpose a table with cells containing links and formulas.
When I try the paste special - transpose, I get blank cells or cells
containing links that were not in the original table. What's wrong?

When the formula cells transpose, their cell references change
according to their new position. One workaround for this is to
highlight the range to transpose, the search for the = sign and replace
with your initials. This converts the dynamic formulas to a static
text string. You can then transpose. Afterwards, search for your
initials and replace with the = sign to convert back to formulas.

Thanks, that does work.

"Dave O" wrote:

When the formula cells transpose, their cell references change
according to their new position. One workaround for this is to
highlight the range to transpose, the search for the = sign and replace
with your initials. This converts the dynamic formulas to a static
text string. You can then transpose. Afterwards, search for your
initials and replace with the = sign to convert back to formulas.