Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 5th 08, 04:05 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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?

  #2   Report Post  
Old December 5th 08, 04:11 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,480
Default Copied formula produces unexpected copied results

Hi Robert

Sounds like calculation mode has got set to Manual.
Press F9 to recalculate and all the values should change

To alter the setting, ToolsCalculationAutomatic.

Calculation mode gets set by the first workbook opened in that Excel
session. Your Supervisor needs to take a look at that workbook, alter it's
setting as well and save it, else the same thing is likely to happen again.


--
Regards
Roger Govier

"Robert" wrote in message
...
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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
#N/A displayed when Lookup Formula is copied Rachael F Excel Worksheet Functions 0 February 25th 08 11:48 AM
Copied formula won't calculate Lisar. Excel Worksheet Functions 3 August 1st 07 10:26 PM
Unwanted formula being copied to cell Gene Excel Discussion (Misc queries) 3 April 17th 07 06:02 PM
Excel formula copied down Pat Excel Discussion (Misc queries) 4 August 25th 05 11:02 PM
I get a 0 value when a formula is copied to another cell arleen a. Excel Discussion (Misc queries) 4 August 9th 05 12:02 AM


All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017