| 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 | |||
Hybrid Mode
