Problem in Transpose

[Hetal Vora]

Hi,

I am using Excel 2007.

I was trying to Transpose data, which are having Absolute Reference.

When I transpose it, it does not transpose it correctly. Infact it shows
different Absolute Reference after transpose done, which it should not.
Example, $A$4 after tanspose it will show $E$8 like wise. Hence the result
are also different.

Same problem i found in various machine. Also i found same problem in Excel
2003.

I observe it, when the cells are having more longer formula, it shows such
error.

It seems it is a bug in Microsoft.

Please help.

Warm regards.

Hetal

 

[David Biddulph]

What was your original formula, and what was the process you went through to
do the transpose? What result did you want, and what result did you get?