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

Problem in Transpose
 

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?
--
David Biddulph

"Hetal Vora" <Hetal wrote in message
...
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