Recalculate the value of NOW()?

[shiphen]

Hello

How do I get Excel to recalculate the value of NOW()?

Obviously one way is to save the file and re-open it, but short of using VBA, is there any way of forcing a reculation - e.g. using a keyboard shortcut?

Thanks

J

 

[macattackpro]

Re: How do I get Excel to recalculate the value of NOW()?

Shift + F9 will calc the sheet from a keyboard shortcut.

 

[FormR]

Re: How do I get Excel to recalculate the value of NOW()?

using a keyboard shortcut?

Hi, try F9.

 

[shiphen]

Re: How do I get Excel to recalculate the value of NOW()?

Shift + F9 will calc the sheet from a keyboard shortcut.

Yes! Shift F9 seems to work (I've not ye tried it with plain F9)

Thanks

J

 

[macattackpro]

Re: How do I get Excel to recalculate the value of NOW()?

The difference is Shift+F9 calcs just the worksheet while F9 will do the whole workbook. Depends on your needs...

 

[shiphen]

Re: How do I get Excel to recalculate the value of NOW()?

The difference is Shift+F9 calcs just the worksheet while F9 will do the whole workbook. Depends on your needs...

Perfect - thanks

J