All of a sudden any new formula I create will not calculate unless I write the formula, leave that cell, click inside the equation editor for that cell and then hit return. This occurs whether I cut and paste a formula or create the formula in the cell.
Any suggestions?
have you somehow turned off automatic calculation? In the Formula toolbar (2007 and later) make sure Formula calculation is set to Automatic
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
In Excel 2003 check Tools > Options > Calculation tab > Automatic
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks