Forum Discussion
DavidLewies
Jan 13, 2022Copper Contributor
MAKE RESULT OF TODAY() AND NOW() FORMULAS STATIC IN A CELL
I need to convert the date and time values from TODAY() and NOW() formulas into static values into specific cells in a template. This has to be protected, in order to prevent the user of the workbook from changing it.
How do I make such a value static in the cell, as we can't use the method of entry via the keyboard (due to the protected status of the cell)?
Microsoft® Excel® for Microsoft 365 MSO (Version 2111 Build 16.0.14701.20254) 64-bit
Hi,
This issue looks like the Bug for Excel 2016 version 2210 (Build 15726.20174).
So revert to Version 2209 (Build 15629.20208) and disable Office updates.1. Start an Office application (such as Excel), and then select File > Account. select Update Options > Disable Updates.
2. Type cmd on the start menu, right click on the Command Prompt, choose Run as Administrator
3. Copy/paste these two commands one at a time and press enter
cd %programfiles%\Common Files\Microsoft Shared\ClickToRun
officec2rclient.exe /update user updatetoversion=16.0.15629.20208FYI:
Update history for Office 2016 C2R and Office 2019
How to revert to an earlier version of Office--------------------------------------------------
*If you use MSI versions of Office, delete windows update program.
4 Replies
Sort By
- NowshadAhmedIron ContributorExcel works live on data. So you can't stop it from calculating and updating a particular cell.
However, this is achievable via macro. The work around is that you write a macro where you select a cell (your entry date calculated via TODAY() or NOW() function) and press a button, which will replace the formula with the resultant value.- DavidLewiesCopper ContributorThanks!
- DavidLewiesCopper ContributorThanks!