When I copy a figure that is the sum of a group of cells and try to paste the
figure in the workbook I'm working in, I cannot paste the figure. It appears
that Excel is copyies the formula and attempts to calculate the formula for
the new cell. When I copy the figure and paste to a new workbook, I can paste
the figure i copied? What is causing me not to be able to copy and paste the
figure in the same workbook I'm working in? Thanks for the help.

Click the figure you want copied (the one figured by the formula) and copy it
using your preferred method (Ctrl+V and the like...)

Select the cell you want to paste the figure to and select Edit>Paste
Special...

At the prompt, select "Value" and click "OK"



"ManhattanRebel" wrote:

> When I copy a figure that is the sum of a group of cells and try to paste the
> figure in the workbook I'm working in, I cannot paste the figure. It appears
> that Excel is copyies the formula and attempts to calculate the formula for
> the new cell. When I copy the figure and paste to a new workbook, I can paste
> the figure i copied? What is causing me not to be able to copy and paste the
> figure in the same workbook I'm working in? Thanks for the help.

1. The copying between one sheet and another in the same workbook will copy the
formula. Edit>Paste Special>Values if you want just the value.

Same for copying between workbooks if you have one instance of Excel running.

2. The copying between workbooks and just getting the value means you have two
instances of Excel running with a workbook open in each instance.


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 13:50:01 -0800, ManhattanRebel
<(E-Mail Removed)> wrote:

>When I copy a figure that is the sum of a group of cells and try to paste the
>figure in the workbook I'm working in, I cannot paste the figure. It appears
>that Excel is copyies the formula and attempts to calculate the formula for
>the new cell. When I copy the figure and paste to a new workbook, I can paste
>the figure i copied? What is causing me not to be able to copy and paste the
>figure in the same workbook I'm working in? Thanks for the help.

MEAD5432
Thank you for the help...You solved my problem

"MEAD5432" wrote:

> Click the figure you want copied (the one figured by the formula) and copy it
> using your preferred method (Ctrl+V and the like...)
>
> Select the cell you want to paste the figure to and select Edit>Paste
> Special...
>
> At the prompt, select "Value" and click "OK"
>
>
>
> "ManhattanRebel" wrote:
>
> > When I copy a figure that is the sum of a group of cells and try to paste the
> > figure in the workbook I'm working in, I cannot paste the figure. It appears
> > that Excel is copyies the formula and attempts to calculate the formula for
> > the new cell. When I copy the figure and paste to a new workbook, I can paste
> > the figure i copied? What is causing me not to be able to copy and paste the
> > figure in the same workbook I'm working in? Thanks for the help.