ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Not able to calculate. (https://www.excelbanter.com/excel-worksheet-functions/7027-re-not-able-calculate.html)

mark_kramarczyk

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


rsorelle

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