View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Robert Robert is offline
external usenet poster
 
Posts: 193
Default Copied formula produces unexpected copied results

My supervisor is working in excel 2007 and copied and pasted a formula down a
range/column of cells. The formula looks right but it posts the same results
as the cell the formula was copied from. For example Cell A1 is 25, A2 is 25,
A3 is =sum(A1+A2) showing 50. Copying that formula down the 3rd column posts
the correct formula ie =sum(B1+B2), =sum(C1+C2). The information for exampe
in B1 is 30, B2 is 30, C1 is 40 & C2 is 40 but the B3 and C3 are showing as
50. The same information as cell A1. This continues on down the page. If you
go back and manually retype the formula, the results are corrected, showing
B3 is 60 and C3 is 80. This problem is affecting every file sent to her from
either 2003 or 2007 and even in new workbooks that she opens. It doesn't
matter if she is copying across a row or down a column. Any Ideas?