This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(121.6, 44%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
I have a specific workbook that asks me if I want to save my changes, even when all I have done is opened it and then closed it.
I have seen suggestions in many places on how to resolve this issue, tried those suggestions, but the issue remains.
Help greatly appreciated.
The site appears to be a bit screwy at the moment. I wrote an Answer which immediately was Deleted so I wrote another which was accepted. Now I see that the original [which had been delete] is restored without any action on my part. Ya gotta love AI [Absolute Idiocy].
The site appears to be a bit screwy at the moment. I wrote an Answer which immediately was Deleted so I wrote another which was accepted. Now I see that the original [which had been delete] is restored without any action on my part. Ya gotta love AI [Absolute Idiocy].
The spam filter on this site can be quite aggressive at times, but so have the spammers lately, so I guess that's why the bar is a tad low.
There are a number of us moderators who monitor deleted posts and restore the legit ones. I can see that several moderators have undeleted posts in this thread today. I just undeleted a comment from James Palmer myself.
Thanks for picking up on this, Erland. I'm aware of what you're confirming but it's the first time I've ever seen a message deleted the instant it was posted — especially since it was a totally innocuous message.
What really perturbs me, though, is that when a message is deleted or under review there is absolutely no explanation other than a reference to the Code of Conduct. How is one expected to avoid repeating the alleged offense without knowing what that offense is? That's further complicated by the fact that the message no longer is available for the accused offender to review or revise.
If it is under review it is has been reported by someone, so that is a manual action. And having handled such reports, it more often whimsical than not.
When it is deleted automatically by the spam filter, it is because is suspected to be spam. Probably you have some pattern there which triggers the AI. And, no, you are not told what. Which of course is frustrating for a legit poster. But it would be heaven sent for a true spammer.
One likes to think that if a poster has assembled as many points as you have, the system should realise that you are unlikely to go rogue and start spamming all over the place.
I am struggling with the behavior of this "forum" and things that I provide an answer to, that seem logical, are getting deleted or comments being deleted.
Please provide me with some guidance. Please.
A Visitor Moderator suggested that is say - May I receive a manual review/restore?
I added a comment to one of the previous answers in this dialog and it was deleted.
Could it be made available for viewing. It has relevance.
There are several causes for automatic changes to be made in a workbook whenever it is opened. For example, dynamic functions such as NOW() & TODAY() automatically update. Links to external sources may be set to update automatically as well. Without access to the workbook it's impossible to be specific as to the cause.
Perhaps the Find feature can help locate dynamic functions & Data> Edit Links... can identify links to other sources.
Your response is a part of a more in-depth response that I received asking a similar question to Google.
I attempted to follow those suggestions with no luck.
I have tried to Fix or Avoid the Prompt by:
Switching to Manual Calculation: Going to Formulas > Calculation Options and set to Manual. No change.
Removing Volatile Functions: Replace functions like =TODAY() with static dates. Used Find to search for all of those listed or more. None exist in my workbook.
Saving as a New File: Used Save As to save the file as a new .xlsx file, which often clears hidden issues. No change.
Checking for Hidden Objects: Pressed Ctrl + G, clicked Special, and selected Objects to find and delete any hidden or invisible shapes. No hidden objects found.
Disabling AutoSave: No change.
Data > Edit Links. Indicated there are no links in the workbook.
I'm at a loss. This behavior started recently, but I have made quite a few changes / additions to macros the workbook and PERSONAL.XLSB
This might seem minor to just click Save every time this prompt appears, but I'm possibly going to make mistakes down the road.
Thanks for weighing in.
-JP
There are several possibilities which automatically can cause changes in a workbook that are not explicitly initiated by the user. Certain functions [e.g., NOW(), TODAY()] update automatically. Links to external sources may be set to update automatically as well.
Without access to the workbook it's impossible to make a specific determination. You can use Find to locate specific content & use Data> Edit Links in the main menu. Other than that, manual examination may be the only means of identifying what triggers the prompt unless someone can offer a programmatic option.