Formulas
 

I'm running MS Office XP Std
My formula's in Excel are not working properly. I've done a check for
updates with office on my pc. how do I fix this?
--
Dave

Hi Dave,

My formula's in Excel are not working properly

In what way are your formulae not working?

---
Regards,
Norman



"Dave" wrote in message
...
I'm running MS Office XP Std
My formula's in Excel are not working properly. I've done a check for
updates with office on my pc. how do I fix this?
--
Dave

Post a formula that isn't working and what it does and wha you expect it to do

Regards,

Peo Sjoblom

"Dave" wrote:

I'm running MS Office XP Std
My formula's in Excel are not working properly. I've done a check for
updates with office on my pc. how do I fix this?
--
Dave

All formula's adding, subtracting, dates
The spreadsheets/formulas work on other computers but not on mine.
How do I post a formula that's not working?
=(C4-B4)/0.04166667
=(today)

"Peo Sjoblom" wrote:

Post a formula that isn't working and what it does and wha you expect it to do

Regards,

Peo Sjoblom

"Dave" wrote:

I'm running MS Office XP Std
My formula's in Excel are not working properly. I've done a check for
updates with office on my pc. how do I fix this?
--
Dave

Any ideas?

"Peo Sjoblom" wrote:

Post a formula that isn't working and what it does and wha you expect it to do

Regards,

Peo Sjoblom

"Dave" wrote:

I'm running MS Office XP Std
My formula's in Excel are not working properly. I've done a check for
updates with office on my pc. how do I fix this?
--
Dave

Hi Dave
you have to describe what the result of your formula is and what result
you did expect. And also provide the values in your referenced cells.
Otherwise we can only guess WHAT is not working for you

--
Regards
Frank Kabel
Frankfurt, Germany

"Dave" schrieb im Newsbeitrag
...
All formula's adding, subtracting, dates
The spreadsheets/formulas work on other computers but not on mine.
How do I post a formula that's not working?
=(C4-B4)/0.04166667
=(today)

"Peo Sjoblom" wrote:

Post a formula that isn't working and what it does and wha you
expect it to do

Regards,

Peo Sjoblom

"Dave" wrote:

I'm running MS Office XP Std
My formula's in Excel are not working properly. I've done a
check for
updates with office on my pc. how do I fix this?
--
Dave

Ok
1 + 1 is an example formula result is NOTHING
None of the formulas work.
There is NO way to post an example I see no way to attach a spreadsheet?

No matter what formula I put in it does not work. Again they work fine on
other PC's.


"Frank Kabel" wrote:

Hi Dave
you have to describe what the result of your formula is and what result
you did expect. And also provide the values in your referenced cells.
Otherwise we can only guess WHAT is not working for you

--
Regards
Frank Kabel
Frankfurt, Germany

"Dave" schrieb im Newsbeitrag
...
All formula's adding, subtracting, dates
The spreadsheets/formulas work on other computers but not on mine.
How do I post a formula that's not working?
=(C4-B4)/0.04166667
=(today)

"Peo Sjoblom" wrote:

Post a formula that isn't working and what it does and wha you
expect it to do

Regards,

Peo Sjoblom

"Dave" wrote:

I'm running MS Office XP Std
My formula's in Excel are not working properly. I've done a
check for
updates with office on my pc. how do I fix this?
--
Dave

Dave

You still haven't shown us what is not happening for you.

Do the formulas show rather than the results?

Perhaps you have ViewFormulas checked in ToolsOptionsView?

Try hitting CRTL + `(above TAB key) to toggle on/off.

Perhaps the cells were formatted as text before you entered the formulas?

Format to General and F2 then <ENTER

Perhaps the formulas are not updating when values change?

ToolsOptionsCalculation. Check "Automatic".

Gord Dibben Excel MVP

On Mon, 6 Dec 2004 11:37:03 -0800, "Dave"
wrote:

All formula's adding, subtracting, dates
The spreadsheets/formulas work on other computers but not on mine.
How do I post a formula that's not working?
=(C4-B4)/0.04166667
=(today)

"Peo Sjoblom" wrote:

Post a formula that isn't working and what it does and wha you expect it to do

Regards,

Peo Sjoblom

"Dave" wrote:

I'm running MS Office XP Std
My formula's in Excel are not working properly. I've done a check for
updates with office on my pc. how do I fix this?
--
Dave

Hi
you may email me an example file but before check 'Tools - Options -
View' and make sure 'Formulas' is unchecked

--
Regards
Frank Kabel
Frankfurt, Germany

"Dave" schrieb im Newsbeitrag
...
Ok
1 + 1 is an example formula result is NOTHING
None of the formulas work.
There is NO way to post an example I see no way to attach a
spreadsheet?

No matter what formula I put in it does not work. Again they work
fine on
other PC's.


"Frank Kabel" wrote:

Hi Dave
you have to describe what the result of your formula is and what
result
you did expect. And also provide the values in your referenced
cells.
Otherwise we can only guess WHAT is not working for you

--
Regards
Frank Kabel
Frankfurt, Germany

"Dave" schrieb im Newsbeitrag
...
All formula's adding, subtracting, dates
The spreadsheets/formulas work on other computers but not on
mine.
How do I post a formula that's not working?
=(C4-B4)/0.04166667
=(today)

"Peo Sjoblom" wrote:

Post a formula that isn't working and what it does and wha you
expect it to do

Regards,

Peo Sjoblom

"Dave" wrote:

I'm running MS Office XP Std
My formula's in Excel are not working properly. I've done a
check for
updates with office on my pc. how do I fix this?
--
Dave

Dave, go back to your original thread and check agai9n.

Gord Dibben Excel MVP

On Mon, 6 Dec 2004 12:51:04 -0800, "Dave"
wrote:

Any ideas?

"Peo Sjoblom" wrote:

Post a formula that isn't working and what it does and wha you expect it to do

Regards,

Peo Sjoblom

"Dave" wrote:

I'm running MS Office XP Std
My formula's in Excel are not working properly. I've done a check for
updates with office on my pc. how do I fix this?
--
Dave

What is your email address?

"Frank Kabel" wrote:

Hi
you may email me an example file but before check 'Tools - Options -
View' and make sure 'Formulas' is unchecked

--
Regards
Frank Kabel
Frankfurt, Germany

"Dave" schrieb im Newsbeitrag
...
Ok
1 + 1 is an example formula result is NOTHING
None of the formulas work.
There is NO way to post an example I see no way to attach a
spreadsheet?

No matter what formula I put in it does not work. Again they work
fine on
other PC's.


"Frank Kabel" wrote:

Hi Dave
you have to describe what the result of your formula is and what
result
you did expect. And also provide the values in your referenced
cells.
Otherwise we can only guess WHAT is not working for you

--
Regards
Frank Kabel
Frankfurt, Germany

"Dave" schrieb im Newsbeitrag
...
All formula's adding, subtracting, dates
The spreadsheets/formulas work on other computers but not on
mine.
How do I post a formula that's not working?
=(C4-B4)/0.04166667
=(today)

"Peo Sjoblom" wrote:

Post a formula that isn't working and what it does and wha you
expect it to do

Regards,

Peo Sjoblom

"Dave" wrote:

I'm running MS Office XP Std
My formula's in Excel are not working properly. I've done a
check for
updates with office on my pc. how do I fix this?
--
Dave

Hi
frank[dot]kabel[at]freenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany

"Dave" schrieb im Newsbeitrag
...
What is your email address?

"Frank Kabel" wrote:

Hi
you may email me an example file but before check 'Tools -
Options -
View' and make sure 'Formulas' is unchecked

--
Regards
Frank Kabel
Frankfurt, Germany

"Dave" schrieb im Newsbeitrag
...
Ok
1 + 1 is an example formula result is NOTHING
None of the formulas work.
There is NO way to post an example I see no way to attach a
spreadsheet?

No matter what formula I put in it does not work. Again they
work
fine on
other PC's.


"Frank Kabel" wrote:

Hi Dave
you have to describe what the result of your formula is and
what
result
you did expect. And also provide the values in your referenced
cells.
Otherwise we can only guess WHAT is not working for you

--
Regards
Frank Kabel
Frankfurt, Germany

"Dave" schrieb im Newsbeitrag
...
All formula's adding, subtracting, dates
The spreadsheets/formulas work on other computers but not on
mine.
How do I post a formula that's not working?
=(C4-B4)/0.04166667
=(today)

"Peo Sjoblom" wrote:

Post a formula that isn't working and what it does and wha
you
expect it to do

Regards,

Peo Sjoblom

"Dave" wrote:

I'm running MS Office XP Std
My formula's in Excel are not working properly. I've
done a
check for
updates with office on my pc. how do I fix this?
--
Dave

Just a thought on the fly. Are your vba Addins "in"?

-----Original Message-----
I'm running MS Office XP Std
My formula's in Excel are not working properly. I've
done a check for
updates with office on my pc. how do I fix this?
--
Dave
.

what are vba Addins? "in"?


"Mark" wrote:

Just a thought on the fly. Are your vba Addins "in"?

-----Original Message-----
I'm running MS Office XP Std
My formula's in Excel are not working properly. I've
done a check for
updates with office on my pc. how do I fix this?
--
Dave
.

Problem solved.
under tools, options, the Calculations tab it was set to manual and not
automatic.


"Dave" wrote:

what are vba Addins? "in"?


"Mark" wrote:

Just a thought on the fly. Are your vba Addins "in"?

-----Original Message-----
I'm running MS Office XP Std
My formula's in Excel are not working properly. I've
done a check for
updates with office on my pc. how do I fix this?
--
Dave
.