XL97: Cutting and Pasting Cells Causes Invalid Page Fault

MORE INFORMATION

In Microsoft Excel, you can transfer information from one cell to another, or from one range of cells to another, by cutting and pasting the information, or by copying and pasting the information. The following table lists the results that occur when you use these methods.

    Method           Result
   ------------------------------------------------------------------------

   Cut and Paste    When you click Cut, the contents of the selected
                    cells are copied to the Clipboard, and the cells are
                    erased. When you click Paste, the contents of the
                    Clipboard are pasted into the worksheet.

   Copy and Paste   When you click Copy, the contents of the selected
                    cells are copied to the Clipboard. The cells are NOT
                    erased. When you click Paste, the contents of the
                    Clipboard are pasted into the worksheet.
				

If you cut and paste one or more cells from a range of cells that contain data that is used by a PivotTable, the PivotTable may not be able to function correctly because the data is no longer available in the original cells. If this occurs, you may receive the error messages listed in this article.

Copying and pasting data from cells that contain data that is used by a PivotTable does not cause a problem because the data is still available in the original cells used by the PivotTable.