ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Date function in Excel that updates only when a doc is changed? (https://www.excelbanter.com/excel-worksheet-functions/63175-date-function-excel-updates-only-when-doc-changed.html)

torino0020

Date function in Excel that updates only when a doc is changed?
 
I only see a date function in Excel that updates everytime you open the
document, regardless if anything was updated or not. Is there a function
that only updates the document if something has actually been updated on that
spreadsheet? If there isn't a function, please advise of any other tools
that will accomplish this task.

Thank you.

rsenn

Date function in Excel that updates only when a doc is changed?
 

You can look at the date the file was modified using Windows Explorer.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=498125



All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com