Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
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 |
#13
|
|||
|
|||
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 . |
#14
|
|||
|
|||
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 . |
#15
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to cut and paste with locked formulas | Excel Discussion (Misc queries) | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |