| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
formula's in cells are not calculating
I have developed a large spreadsheet with many basic formula calculations
For some reason the cells are not recalculating when I drag the + or just adding 3 cells together . I either get 0 or the original cell amount only , even though the cells I am adding have different amounts in them . I have tried tools - options , calculation tab to see if the auto calculation radio button has been unchecked to no avail . I have tried saving , save as , copying to a new worksheet , rebooting , throwing the computer against the wall !! - also to no avail |
|
#2
|
|||
|
|||
|
Couple of thoughts (though I won't guarentee any of them might work) 1. Do you have more than one version of Excel installed ? If you do, ensure that only one is running - this has caught me on more than one occasion 2. Does this problem only occur with this spreadsheet or with Excel in general 3. Which version of Excel are you using - I saw this problem with v2002 and although we cured it we never worked out what we'd done to cure it Anyone got any others? Jon -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=401856 |
|
#3
|
|||
|
|||
|
Thank you for your reply
No i have only one version installed - 2003 Office professional It appears to be only with this spreadsheet , but my colleagues I am working with have also experienced similar problems . the common thread with all them also happens with large detailed spreadsheets "Jon Quixley" wrote: Couple of thoughts (though I won't guarentee any of them might work) 1. Do you have more than one version of Excel installed ? If you do, ensure that only one is running - this has caught me on more than one occasion 2. Does this problem only occur with this spreadsheet or with Excel in general 3. Which version of Excel are you using - I saw this problem with v2002 and although we cured it we never worked out what we'd done to cure it Anyone got any others? Jon -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=401856 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting or moving formula cells without updating formulas | Excel Discussion (Misc queries) | |||
| Heavily linked spreadsheet freezes with "calculating cells 0%" - . | Excel Worksheet Functions | |||
| How do I protect specific cells (like labels and formulas) on a w. | Excel Discussion (Misc queries) | |||
| formulas referencing pivot table cells | Excel Worksheet Functions | |||
| Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
