Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula stopped working....
All of my formula's stopped calculating. I usually enter a date and the
sheet will formulate additional dates. Now a "#name?" shows up. I tried the "Tools" "Options" "Calculation" "Automatic" route and that didn't help. The wierd thing is it works on another computer, but not mine. Please help save my sanity. Ken |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula stopped working....
Could you post one of the formulas?
"Ken Proj mgr" wrote: All of my formula's stopped calculating. I usually enter a date and the sheet will formulate additional dates. Now a "#name?" shows up. I tried the "Tools" "Options" "Calculation" "Automatic" route and that didn't help. The wierd thing is it works on another computer, but not mine. Please help save my sanity. Ken |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula stopped working....
Sean,
The formula is =workday(row column , row Coulmn) The first row column is ually a date and the second is a number to add to it to bring forth a new date. Ken "Sean Timmons" wrote: Could you post one of the formulas? "Ken Proj mgr" wrote: All of my formula's stopped calculating. I usually enter a date and the sheet will formulate additional dates. Now a "#name?" shows up. I tried the "Tools" "Options" "Calculation" "Automatic" route and that didn't help. The wierd thing is it works on another computer, but not mine. Please help save my sanity. Ken |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula stopped working....
I'm using Excel 2000, and don't see that function available. May be available
in other versions. An alternate is: Column A Column B 1 1/1/06 =A1+1 will shows 1/2/06 in B1. It's posible the function you were using was either created via VB, and no longer available, or available on a newer version of Excel... "Ken Proj mgr" wrote: Sean, The formula is =workday(row column , row Coulmn) The first row column is ually a date and the second is a number to add to it to bring forth a new date. Ken "Sean Timmons" wrote: Could you post one of the formulas? "Ken Proj mgr" wrote: All of my formula's stopped calculating. I usually enter a date and the sheet will formulate additional dates. Now a "#name?" shows up. I tried the "Tools" "Options" "Calculation" "Automatic" route and that didn't help. The wierd thing is it works on another computer, but not mine. Please help save my sanity. Ken |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula stopped working....
Do you have the Analysis Toolpak installed (ToolsAddins)?
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Ken Proj mgr" wrote in message ... All of my formula's stopped calculating. I usually enter a date and the sheet will formulate additional dates. Now a "#name?" shows up. I tried the "Tools" "Options" "Calculation" "Automatic" route and that didn't help. The wierd thing is it works on another computer, but not mine. Please help save my sanity. Ken |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula stopped working....
Bob,
You Da Man!!!!!!!! I don't know who turned this option off on my pc but as soon as I turn it on again, ba da bing. My houses will finish on time.... Thank you. "Bob Phillips" wrote: Do you have the Analysis Toolpak installed (ToolsAddins)? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Ken Proj mgr" wrote in message ... All of my formula's stopped calculating. I usually enter a date and the sheet will formulate additional dates. Now a "#name?" shows up. I tried the "Tools" "Options" "Calculation" "Automatic" route and that didn't help. The wierd thing is it works on another computer, but not mine. Please help save my sanity. Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula not working for me now | Excel Worksheet Functions | |||
Auto Extended Formula not working | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Excel2000 A working formula has {braces} which disappear. Why? | Excel Worksheet Functions |