| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 77073 | 2007-02-25 23:37:00 | excel help | globe (11482) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 528153 | 2007-02-25 23:37:00 | i have created a stock spreadsheet that keeps track of stock added and removed using the sum finction. if the current stock drops below a specific level i have used conditoinal formatting to flag that this item requires restock. Now i have come back to this spreadsheet this morning after leaving the office machineon all weekend and now the functions no longer work without having to double click on the cell then press enter. this is a one off fix only and has to be done every time. any ideas what may have caused this or how I can fix it (without recreating the entire spreadsheet that is) cheers |
globe (11482) | ||
| 528154 | 2007-02-26 01:41:00 | HAve a look to see whether the Tools>Options, Calculation tab has had the "Automatic" setting changed to "Manual" - if so, change it back and you'll be fine. This happened in a spreadsheet I was working on recently - a resources-related problem I think, as I was attempting the copying of a couple of whole columns and pasting across multiple worksheets and getting failure error messages on the Paste. Then noticed the auto recalc function had switched itself off, possibly as a result of the resources running out... | johcar (6283) | ||
| 1 | |||||