Microsoft KB Archive/109185

{|
 * width="100%"|

XL5: GP Fault Cutting and Pasting Formula to New Workbook

 * }

-

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.
 * 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 :

Technology :