ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Not Calculating Formulas. (https://www.excelbanter.com/excel-worksheet-functions/97340-not-calculating-formulas.html)

msmouse

Not Calculating Formulas.
 

My Excel is not calculating the formula's. If you browse through an
explorer and open the file directly, they WILL NOT work. Even if you
retype the calculation, it will not work. Check settings, it is set to
do it automatically, not a manual issue. When you open a blank excel
document, and then browse to and open the templets, it WILL work. The
calculations work as intended.


--
msmouse
------------------------------------------------------------------------
msmouse's Profile: http://www.excelforum.com/member.php...o&userid=35997
View this thread: http://www.excelforum.com/showthread...hreadid=557832


Dave Peterson

Not Calculating Formulas.
 
Sometimes this'll work...

Select all the cells
edit|Replace
what: = (equal sign)
with: =
replace all

Maybe it'll wake excel up!

msmouse wrote:

My Excel is not calculating the formula's. If you browse through an
explorer and open the file directly, they WILL NOT work. Even if you
retype the calculation, it will not work. Check settings, it is set to
do it automatically, not a manual issue. When you open a blank excel
document, and then browse to and open the templets, it WILL work. The
calculations work as intended.

--
msmouse
------------------------------------------------------------------------
msmouse's Profile: http://www.excelforum.com/member.php...o&userid=35997
View this thread: http://www.excelforum.com/showthread...hreadid=557832


--

Dave Peterson

msmouse

Not Calculating Formulas.
 

I thought I should mention that it does this for every excel file. Not
just one.


--
msmouse
------------------------------------------------------------------------
msmouse's Profile: http://www.excelforum.com/member.php...o&userid=35997
View this thread: http://www.excelforum.com/showthread...hreadid=557832



All times are GMT +1. The time now is 01:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com