Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
It's not relevant.. I just can't
Display Excel Document Properties using a formula
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I am pretty sure I remember this being possible in past --
I want to be able to display document properties, specifically a documents last saved date using a formula.
I know I can do it using vba or a custom function -- but the document I am working on can not allow macro's to be enabled.
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
4 answers
Sort by: Most helpful
-
Anonymous
2016-01-31T18:00:46+00:00 -
Anonymous
2016-01-31T08:11:55+00:00 Why is it a problem to enable macros???
-
Anonymous
2016-01-30T22:28:33+00:00 In order to use a user defined function, you have to enable macro's which is the problem.
I guess what is irritating is that I think I remember this being a built in function in the past -- so I am not sure why they don't have it anymore.
-
Anonymous
2016-01-30T22:10:24+00:00 I think you have to use an User-Defined Function: