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.