Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Paste Special Transposition Has Unexpected Results

XL2000: Paste Special Transposition Has Unexpected Results

View products that this article applies to.

This article was previously published under Q215250

↑ Back to the top

Symptoms

If you use a formula to copy cells from another worksheet, and you then use the Paste Special command to transpose those cells, both the formula and the values in the pasted cells change.

↑ Back to the top

Workaround

To work around this issue, you can use the Paste Special command to paste only the values. To paste only the values, click Values under Paste in the Paste Special dialog box.

CAUTION: This workaround breaks the links to the original cells in sheet 1.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

More information

When you transpose cells, change rows to columns and columns to rows.

The behavior described in the "Symptoms" section of this article occurs if the following conditions are true:
  1. You start Excel, and then create the following spreadsheet on sheet 1 of a new workbook:
       A1: 1
   A2: 2
   A3: 3
  2. You click the Sheet2 tab to open sheet 2.
  3. You select cells A1:A3.
  4. In the formula bar, you type the following equation:
    =SHEET1!A1:A3
  5. You press CTLR+SHIFT+ENTER to enter the formula as an array.

    The cells on sheet 1 are duplicated on sheet 2.
  6. In sheet 2, you select cells A1:A3.
  7. On the Edit menu, you click Copy.
  8. Select cell C3.
  9. On the Edit menu, you click Paste Special.
  10. You click to select the Transpose check box, and then click OK. The values change to zero and the formula also changes.

↑ Back to the top

Keywords: KB215250, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 215250
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 226