• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Disable Automatically Updating Date Formulas

D

Dokat

Member
Hi,

Is there a way for data formula to not automatically update every time I open Excel. I don't want to turn on manual calculations as I want all other formulas to be updated in the worksheet wen I open.


Thanks
 
Not if Date formula (ex. "TODAY()") is in same sheet as other calculations.

Work around is to use VBA to populate specific cell with date value.

In VBA "Date" serves same function as TODAY() in worksheet. So use a button or some other method to call the procedure when you want to update the date.

Alternately, you can set calculation for entire sheet to manual. Then use .Calculate in VBA for specific range. But I don't recommend this approach.

See link for reference.
http://www.cpearson.com/excel/optimize.htm
 
You must log in or register to reply here.
Back
Top