Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 7th 04, 08:20 PM
Matt
 
Posts: n/a
Default Paste is is copying in formula, but display is wrong.

Hello all,



We are having a very strange problem with Excel (2003). In a work sheet we
have a simple Total Cell and a number of cells behind it with the data..
simply put,



C6 is =sum(D6:Z6) Which, let's say, equals 30. No problem. but, If I do a
copy of C6 and paste it into C7, C7 now equals 30 BUT the formula for C7
pasted correctly.



So the Cell C7 now displays 30, but the formula in the (fx)Formula box shows
that the formula for C7 is =sum(D7:Z7)



The actual total for D7 thru Z7 is 22..





If I click on Cell C7 and hit F2 to edit the cell formula, and then hit
enter without changing a thing, the cell display changes to 22 like it
should be.



I created a new sheet to make sure the system itself was not messed up, but
the new sheet works fine!



Help!



Thanks a lot,



Baffled Matt





  #2   Report Post  
Old December 7th 04, 08:24 PM
Frank Kabel
 
Posts: n/a
Default

Hi
goto 'Tools - options - Calculate' and check 'Automatic calculation'

--
Regards
Frank Kabel
Frankfurt, Germany

"Matt" schrieb im Newsbeitrag
...
Hello all,



We are having a very strange problem with Excel (2003). In a work

sheet we
have a simple Total Cell and a number of cells behind it with the

data..
simply put,



C6 is =sum(D6:Z6) Which, let's say, equals 30. No problem. but, If

I do a
copy of C6 and paste it into C7, C7 now equals 30 BUT the formula for

C7
pasted correctly.



So the Cell C7 now displays 30, but the formula in the (fx)Formula

box shows
that the formula for C7 is =sum(D7:Z7)



The actual total for D7 thru Z7 is 22..





If I click on Cell C7 and hit F2 to edit the cell formula, and then

hit
enter without changing a thing, the cell display changes to 22 like

it
should be.



I created a new sheet to make sure the system itself was not messed

up, but
the new sheet works fine!



Help!



Thanks a lot,



Baffled Matt





  #3   Report Post  
Old December 7th 04, 08:37 PM
Matt
 
Posts: n/a
Default

Hi Frank and thanks.

Strange though, I did that but Automatic was already seleceted, however I
hit the 'Calc Sheet' and it recalced everything and seems to be working ok
now. Go figure!

Thanks,

Matt

"Frank Kabel" wrote in message
...
Hi
goto 'Tools - options - Calculate' and check 'Automatic calculation'

--
Regards
Frank Kabel
Frankfurt, Germany

"Matt" schrieb im Newsbeitrag
...
Hello all,



We are having a very strange problem with Excel (2003). In a work

sheet we
have a simple Total Cell and a number of cells behind it with the

data..
simply put,



C6 is =sum(D6:Z6) Which, let's say, equals 30. No problem. but, If

I do a
copy of C6 and paste it into C7, C7 now equals 30 BUT the formula for

C7
pasted correctly.



So the Cell C7 now displays 30, but the formula in the (fx)Formula

box shows
that the formula for C7 is =sum(D7:Z7)



The actual total for D7 thru Z7 is 22..





If I click on Cell C7 and hit F2 to edit the cell formula, and then

hit
enter without changing a thing, the cell display changes to 22 like

it
should be.



I created a new sheet to make sure the system itself was not messed

up, but
the new sheet works fine!



Help!



Thanks a lot,



Baffled Matt









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
Paste Special Question Kevin Excel Discussion (Misc queries) 3 November 30th 04 11:34 PM


All times are GMT +1. The time now is 02:49 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017