Formula is correct, but result will not show

B

bryanchughes

I'm using Excel 2007.

I have been using a spreadsheet for a basic accounting project and had the
following basic formula: =5x+5y

When I use the pull down function to copy this formula down several rows, it
gives me the proper formula (i.e. =6x+6y, =7x+7y), but the answer is just a
copy of the answer from the original formula.

I have clicked the little table and it only gives me three options: copy
cell, format only, fill without formatting.

The spreadhseet that i am using has worked for over 4 years, and now it no
longer works. I cant get this to work in any spreadsheet now and have even
removed and then reinstalled office.

It's probably something dumb I did, but I am stuck. Please help!
 
M

Max

it gives me the proper formula, but the answer is just a
copy of the answer from the original formula

Sounds like calc is set to manual. Try pressing F9 to recalc. Does it
compute properly now? In xl03, click Tools>Options>Calculation tab to re-set
calc mode to Auto. Maybe you could try equiv. steps in your xl07.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---
 
R

Reitanos

In Excel 07 the steps are:
Click the Office Beach Ball
Click Excel Options button (at bottom)
Select Formulas (on left)
And under the word Calculation make sure it is set to Automatic
Choose OK
 
B

bryanchughes

This advice and the advice given by Retanos worked. I actually went to the
formulas tab, and made the switch under the calculation options button.
Thanks for the help!
 

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