"Last edit" field shows last open date instead of last modification

1. Correct. Problem requires a file name formula. 
2. I thought of that but problem happens when last edit field is in somewhere else in the drawing too.
3. Correct. I did that and sent the file back to you. Could you open it and see that one of the shapes update its date each time file is opened?

By the way, I could solve my problem by using =DOCLASTSAVE() instead of automated last edit field.

Hi Volkan,

Thanks for your updates.

I’m glad to hear that you can work around the issue by using =DOCLASTSAVE().

If you need further help on this issue, I’d like you to do the following.

As I can’t reproduce the issue with the file I sent to you contains a file name with the file formula in a text box and the last edit date in a shape and it seems that you also can’t reproduce the issue in your environment with the original file, I’d like you to record a video showing the issue I mentioned in #2 above in your environment. In the video, please show how you create the file (a file name with the file formula in a text box and the last edit date in a custom shape or in a text box) and when the issue happens. It may be a good reference for our further troubleshooting.

About #3, when I save the last field shape to Favorites and drag it to the original test file, I can reproduce the issue in my environment.

So could you take some time to let us know the each step you create the small reproducing file in the video for our investigation? After recording the video, you can save it in a shared link and provide the link in the private message I sent to you.

Thanks for your effort.

Cliff

Hello,

It is a shape with formatted text, ready fields and a custom formula field. Picture shows fields:

I tried removing other fields in a combinative manner. When I remove the file name custom formula, last edit stops to update on file opening. 

It is also still dependent on the number of other shapes. To sum up, if last edit field is in a shape with my custom filename field AND there are two or more flowchart shapes, last edit updates on file opening. (Other last edit fields in the very same page do not update if they dont have filename formula in the same shape!)

I'm ok with writing file names by hand to fix this but could you find the root cause? I believe this looks like a bug rather than an expected behavior. I have around 20 files so it is ok to write filenames by hand but in future, one might actually need to use similar formulas and last edit field.

Hello,

No, as I said I used "Last edit" field from Visio fields. I did not use formulas to get the date and time.

So I use this:

When I add a shape to my drawing last edit time, of course, updates. I have no problem with that. My problem is: last edit field also updates when I open the file (even without touching anything, even in read only mode).

And I dont normally use hour, minute and seconds detail. But I added them to show you the problem. Otherwise you would need to wait a day to see last edit field updates when file is opened.

I see that I was not able to be clear what I meant with adding shapes and last edit field updates.

If I create and save a file with only last edit field, last edit field works normal. It does not update just because I opened the file. It only updates If I add or move something.

If I create and save a file with a last edit field plus a shape, last edit field again works normal. It does update when I add the shape of course but It does not update just because I opened the file. It only updates If I add or move something.

So far all behaviours are normal.

However, If I create and save a file with last edit field plus two or more shapes, last edit field updates whenever I open the file too. If you can check, please open the file I uploaded as minimum working example. Open and close the file a few times. You will see that last edit field is updating with each and every opening date and time. Its not normal.

Hello,

I created a special stencil based on usual flowchart stencil. I added formulas that I explained in main post to all shapes and changed default shape data names. I can share the stencil too. 

I also created some shapes to serve as title blocks. One of them ("Akış") shows file name, file creation and file modification date.

File name and creation date is shown without any problem by the fields. However, "Last edit" field shows current (file opening) date instead of last modification date.

If I remove all shapes from the document except "Akış" which includes last edit field, then last edit data is shown correctly. But If I use some other shapes then last edit field shows file opening date and time.

So I strongly believe it is one of the formulas I used is creating this. I would like to learn how to make last edit field behave correctly or learn alternative formulas that does not trigger last edit to change.

I'm not using onedrive, I just uploaded it for you. 

Issue is happening with all files that I created with this stencil.

Screenshot of the problem:

Account page:

The file I uploaded can stay public. 

Woudl you like me to upload shape sheet report?