Formula is correct, but result will not show
 

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!

Formula is correct, but result will not show
 

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 ToolsOptionsCalculation 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
---

Formula is correct, but result will not show
 

In Excel 07 the steps a
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

On Sep 20, 7:07*pm, bryanchughes
wrote:
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!

Formula is correct, but result will not show
 

=5x+5y doesn't sound like a formula. If those are supposed to be cell
references, perhaps you intended to say =X5+Y5 ?

If you are trying to multiply variables which you had named x and y, the
perhaps you intended to say =5*x+5*y ?
--
David Biddulph

"Reitanos" wrote in message
...
In Excel 07 the steps a
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

On Sep 20, 7:07 pm, bryanchughes
wrote:
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!

Formula is correct, but result will not show
 

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!

"Max" wrote:

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 ToolsOptionsCalculation 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
---

Formula is correct, but result will not show
 

Welcome, glad it resolved your issue.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---
"bryanchughes" wrote in message
...
This advice and the advice given by Reitanos worked. I actually went to
the
formulas tab, and made the switch under the calculation options button.
Thanks for the help!