Dragging a formula across the row in 2007

C

Carolyn

When I drag from one cell to the next it puts in the correct forumla (i.e.,
O16+O31 is P16+P31 in the next cell); however, it puts the value from the O
column in the P cell. To get the correct sum in P I have to re-enter the
forumla (P16+P31).

This is also happening with cells that have numbers referring to other
worksheets. If I drag it to the next column it shows the relative change but
puts in the value from the copied cell. I can go into the formula bar and
P68 in Worksheet!P68, hit enter and then correct value appears.

I am working between 07 and 03 Excel and on different computers throughout
the day.

Any ideas
 
M

Michael_R

Sounds like your Calculation Option is set to Manual.
In 2007 you set this on the Formula Bar, Calculation options. If you change
it to "Automatic" you should get immediately recalculated results.

Alternatively, if you don't want to change this setting you can manually
recalculate your workbooks by using F9 after copying the formulae.

Michael
 
C

Carolyn

Thanks, Michael. That was the answer. As far as I know, I am the only one
who had been in this document and until today everything calculate
automatically so I immediately assumed a more esoteric problem!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top