Problem in Transpose
 

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