Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
my excel formulas have quit working
I use excell daily - but this morning all of my formulas, is each
spreadsheet, will not work or copy. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
my excel formulas have quit working
Try hitting F9, do your formula's update now? If so, you have automatic
calculation turned off... <Tools<Options "Calculation" tab Check "Automatic" -- Regards, Dave "MR" wrote: I use excell daily - but this morning all of my formulas, is each spreadsheet, will not work or copy. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
my excel formulas have quit working
F9 did not make a difference - Each and every one of my spreadsheets has quit
working (formulas) this morning. "David Billigmeier" wrote: Try hitting F9, do your formula's update now? If so, you have automatic calculation turned off... <Tools<Options "Calculation" tab Check "Automatic" -- Regards, Dave "MR" wrote: I use excell daily - but this morning all of my formulas, is each spreadsheet, will not work or copy. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
my excel formulas have quit working
F9 did not do the trick
"David Billigmeier" wrote: Try hitting F9, do your formula's update now? If so, you have automatic calculation turned off... <Tools<Options "Calculation" tab Check "Automatic" -- Regards, Dave "MR" wrote: I use excell daily - but this morning all of my formulas, is each spreadsheet, will not work or copy. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
my excel formulas have quit working
I had the same thing happen occassionally. For instnace I entered the formula
=right(A2,4) and it stayed as that. F9 didn't help. Closing and reopening the file either. "MR" wrote: F9 did not do the trick "David Billigmeier" wrote: Try hitting F9, do your formula's update now? If so, you have automatic calculation turned off... <Tools<Options "Calculation" tab Check "Automatic" -- Regards, Dave "MR" wrote: I use excell daily - but this morning all of my formulas, is each spreadsheet, will not work or copy. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
my excel formulas have quit working
I solved it!!! It actually was the F9 problem, but hitting F9 that particular
item. So I had to change the automatic formula update item in the tools. Crazy...I never turned it off, but I had to change it back on each spreadsheet. Thank You!!! "Oscar of Issaquah Salmon Days Festival" wrote: I had the same thing happen occassionally. For instnace I entered the formula =right(A2,4) and it stayed as that. F9 didn't help. Closing and reopening the file either. "MR" wrote: F9 did not do the trick "David Billigmeier" wrote: Try hitting F9, do your formula's update now? If so, you have automatic calculation turned off... <Tools<Options "Calculation" tab Check "Automatic" -- Regards, Dave "MR" wrote: I use excell daily - but this morning all of my formulas, is each spreadsheet, will not work or copy. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel formulas and recalculation | Excel Discussion (Misc queries) | |||
How can I get EXCEL formulas to work in Works? | Excel Worksheet Functions |