#1
|
|||
|
|||
all of my formulas quit automatically calculating
spreadsheet i use every day...today, the formulas quit automatically calculating. i have to reinput the formulas in each section. all sections have quit calculating until i redo.
i remember a field in the toolbar (which i cannot find now) that said something like, formulas automatically calculate"? can't find in this version of Excel, Windows 7 |
#2
|
||||
|
||||
Do you mean the formulas stay there and don't do anything?
But when you edit them they work? Then probably those cells have been formatted as text Format as General and hit enter
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Yes, Pecoflyer. my formula is still in each cell. but totals do not tally when i insert values or make changes. i had to add the "calculate now" button to update all the formulas.
|
#4
|
|||
|
|||
You could try:
Press File (on the Ribbon), then Options. In the Excel Options dialog select Formulas. Check that Automatic Calculation is enabled. |
#5
|
||||
|
||||
Or:
Formulas tab, Calculation Options dropdown on the right, change to Automatic. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hyperlink: open the document only once, quit & reopen PP, hyperlink doesnt work anymore | quanghuynguyenhua | PowerPoint | 0 | 10-10-2015 06:17 PM |
Run-time error in VB.NET program that worked under Office XP but quit when upgraded to Office 2007 | Dick_in_Dallas | Misc | 0 | 03-14-2015 07:07 PM |
Excel 2010 changing external link formulas automatically on Webdav mapped drive | dirkswart | Excel | 2 | 10-07-2013 12:44 PM |
Word Crash on Quit | masomenos | Word | 2 | 11-09-2010 12:35 AM |
Excel 2003 will not terminate with application.quit | Peter Schellenbach | Excel | 12 | 03-14-2006 05:28 PM |