Excel 2002 transpose not working

J

joeeng

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?
 
D

Dave O

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.
 
Top