#value

[Nasir]

I have some functions calculating certain values. All is fine, but all
of a sudden I have this strange #value sign there in the cells which
contains the function to calculate some value. If I click on the cell,
and then hit enter, it calculates fine. However, it doesnt calculate
for the whole sheet by itself. I have used auto calculate and manual
both, not working.(It used to calculate by itself before) Someone
please help.

Thanks,
NM

 

[elachowitz]

Try this:

Private Sub Workbook_Open()
Application.CalculateFullRebuild
End Sub

Save and restart the file...

 

[Nasir]

Thanks, it is working now. I havent tried your suggestion yet. My
assumption is, I had two work book open, perhaps some error was
generated from that workbook to the one I was working on. Doesn't make
sense to me, but it is working. If I close that workbook(which I think
is causing the trouble), and then open the workbook I am working
on(calculations) then it works fine.
Still thanks for your help,
Nasir.