Recalculating Formula - Getting the wrong answers
 

I'm trying to do my check book in excel. When I copy the formula in my last
column. For instance =F482-D483+E483 and then in the next column
=F483-D484+E484, etc. It is not recaluclating my formula - it is just taking
the answer from where I started my copy and copying that down. It just
started doing this - I've been doing my checkbook in excel for 3 years now.
I used to just drag and drop my balance column and it would calculate all of
the checks that I wrote and all of the deposits I made. Now it is wanting me
to manually type each formula - this can be very time consuming. Excel
allows me to drag, but it isn't recalculating the correct answer just coping
the answer from where I started my dragging from. Help!!!!

Sounds like your calculation has been set to manual.

Tools - Options - Calculation - Automatic

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"skherzog" wrote in message
...
I'm trying to do my check book in excel. When I copy the formula in my
last
column. For instance =F482-D483+E483 and then in the next column
=F483-D484+E484, etc. It is not recaluclating my formula - it is just
taking
the answer from where I started my copy and copying that down. It just
started doing this - I've been doing my checkbook in excel for 3 years
now.
I used to just drag and drop my balance column and it would calculate all
of
the checks that I wrote and all of the deposits I made. Now it is wanting
me
to manually type each formula - this can be very time consuming. Excel
allows me to drag, but it isn't recalculating the correct answer just
coping
the answer from where I started my dragging from. Help!!!!

ToolsOptions, Calculation tab, check Automatic

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"skherzog" wrote in message
...
I'm trying to do my check book in excel. When I copy the formula in my
last
column. For instance =F482-D483+E483 and then in the next column
=F483-D484+E484, etc. It is not recaluclating my formula - it is just
taking
the answer from where I started my copy and copying that down. It just
started doing this - I've been doing my checkbook in excel for 3 years
now.
I used to just drag and drop my balance column and it would calculate all
of
the checks that I wrote and all of the deposits I made. Now it is wanting
me
to manually type each formula - this can be very time consuming. Excel
allows me to drag, but it isn't recalculating the correct answer just
coping
the answer from where I started my dragging from. Help!!!!