Recalculate the Now() function on a second basis

Hi anyone,

How can i keep running the Now() function in Excel Spreadsheet without pressing F9 and also not using VBA code.

Here i am in the situation to grab the data on a Timely basis.For that i am forced to recalculate the cell which is holding the Now() function , on Every Second.

can you please tell me, is there any way to recalculate all the cells in every second OR is there any way to run the Now() function every second?

you answers would be appreciate without using Vba....

Thanks and Regards...

There is no way to do that. Excel evaluates formulas either automatically, meaning when their arguments have changed, or manually, meaning when you tell it to. Either way, a user action is required to trigger the update.
There may be a really ugly hack involving allowing circular references to force continuous updates, but that's such a horrible idea that I won't even mention it here... :p

Why don't you want to use VBA? Excel gives you an OnTime method that's precisely meant for this sort of requirement.

Thanks for your support, but i know it will be possible in VBA, why not in Excel? becuase Now() function are volatile functions. I dont want to go VBA for all time. I need something which is precise in the Worksheet itself.

Volatile functions are still only updated when a change occurs somewhere. The difference to non-volatile functions is that the change doesn't have to occur in its precedents, i.e. cells that the function refers to as arguments. No user action -> no changes -> no updates.