Not able to calculate.
I am having a similar problem where the workbook refuses to calculate. The calculation is set to automatic, although I have tried to force it with F9, but that doesn't work either. Even entering a new formula such as, =Today(), returns 1/1/1900 instead of the current date. The really strange part is that it is not repeatable. Some times the workbook will calculate properly, and other times it won't. Additionally, once I open a workbook that won't calculate any additional workbooks I open won't calculate either. It has happened to more than one workbook and at more than one computer, but I can't reliably duplicate the problem. Does anyone have any experience tracking down a problem like this??? -- mark_kramarczyk ------------------------------------------------------------------------ mark_kramarczyk's Profile: http://www.excelforum.com/member.php...o&userid=16811 View this thread: http://www.excelforum.com/showthread...hreadid=270157 |
Has anyone offered a solution to this problem?
"Kquinn" wrote: On a worksheet that I have been using for some time, my formulas do now not recongize new numbers. When I now enter a number that is within the formula range the formual does not change. This seems to have happend all of a sudden. Any suggestions? |
All times are GMT +1. The time now is 01:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com