XL5: GP Fault Cutting and Pasting Formula to New Workbook

ID: Q109185


The information in this article applies to:
  • Microsoft Excel for Windows, version 5.0


SYMPTOMS

In Microsoft Excel, if you cut a cell (or group of cells) that contains a formula that uses a defined name and has been filled across adjacent cells, and then paste that cell on a new workbook, you receive a general protection (GP) fault.


WORKAROUND

To move a formula that uses a defined name and has been filled across adjacent cells to another worksheet without receiving the GP fault, do either one of the following:

  • Copy the formula and paste it on another workbook, then delete the shared formula from the original workbook.


  • -or-

  • Cut the formula and paste it on another worksheet in the same workbook. Note that if the formula uses a local name, the cell you paste the formula in will display the #REF error value. If the formula uses a local name, you must modify the formula to include the sheet name when you move it to the new worksheet.



MORE INFORMATION

You can use the fill option in Microsoft Excel to quickly copy information to adjacent cells. For example, you can fill adjacent cells with a formula that uses relative references, rather than typing the formula into individual cells.

For more information about filling a range of adjacent cells, choose the Search button in Help and type the following:

filling

Additional query words:

Keywords : xlwin
Version : WINDOWS:5.0
Platform : WINDOWS
Issue type :


Last Reviewed: October 22, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.