Copy formula, paste special value add transpose into another formu

[jayel]

Here are my issues:

1. I am copying a row of formulas in one workbook and am trying to add the
values to a column of formulas located in a separate workbook. When I try to
do this, Excel 2003 says that an error occured and it goes into recovery
mode. I was just deployed onto 2003 and the workbooks were created in
XL2000. Note, I am on still on Windows 2000 (not sure if this is causing a
problem). I had no issues performing this routine in XL2000.

2. To test, in XL2003 new workbook, I copied a row of formulas from sheet1.
In sheet2, I paste special, value, add, transpose into a column of existing
formulas. A separate issue occured.

Sheet1:

10 20 30
10 10 10
=SUM(A1:A2) =SUM(B1:B2) =SUM(C1:C2) (row copied)


Sheet2, prior to paste special, value, add, transpose:

10 30 =SUM(A1:B1)
20 50 =SUM(A2:B2)
30 70 =SUM(A3:B3)

Sheet2, post paste special, value, add, transpose:
result: sheet1 formula added to Sheet2 column C values.

A B
10 10 =(SUM(A1:A2))+20
20 20 =(SUM(B1:B2))+40
30 30 =(SUM(C1:C2))+60

EXPECTED result: value of copied formula added to Sheet2 column C formulas.
A B
10 10 =(SUM(A1:B1))+20
20 20 =(SUM(A2:B2))+30
30 30 =(SUM(A3:B3))+40

This worked fine in Excel 2000.......any help would be appreciated!!!!!!