Date Logic Locking up and not calculating

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

Sorry Jan, I am not sure if I was clear enough. My point is that m
Excel function is not updating when it should and I cannot figure ou
why. It updates only when I go into the formula bar and hit enter. I
I calc the sheet or workbook, it does not update.

E
 
Hi ExcelMonkey,
Sorry Jan, I am not sure if I was clear enough. My point is that my
Excel function is not updating when it should and I cannot figure out
why. It updates only when I go into the formula bar and hit enter. If
I calc the sheet or workbook, it does not update.
Click to expand...

Maybe a file corruption?

check www.jkp-ads.com/CorruptFiles.htm

for some pointers.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Hi ExcelMonkey,

Check that calculation is set to manual and that your macro is not resetting
the calculation mode.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to lock a range from calculating formulas? 1
Getting #VALUE in cells with User Defined Functions 2
Letting users calculate Excel forms on the web while hiding the logic 3
File calculates with each cell input 2
Excel Help with dates 2
Switching to Manual Calculation stalls workbook 1
formulas not auto calculating and will not calculate 8
Date Logic Locking up and not calculating 1

Back
Top