If we want to transpose a range of cells in a row which contains "sum"
formula, the values in the row change after transpose. One olution is to use
"paste link". However the "paste link" is disabled when the transpose
checkbox is checked.
Is there any way out to retain the cell values the same while transposing
the range of cells?
Thank you.