0

I am managing a repository where two companies exchange specification documents. Some specifications are in Excel 2019. By default, Microsoft Excel is installed with auto save feature ON. It's the little switch located at top left corner of the window. This setting can be disabled permanently in Excel settings. Even if I do that and I disable the AutoSave, I am still getting automatic saves:

AutoSave is disabled, yet Excel is saving the document anyway.

Also, I can't demand all users in all companies to disable their AutoSave just because I want them to. I need to disable this feature per document, so that they can't save changes in my document unless they specifically click SAVE. I can't give them read-only access, since sometimes, the changes are desired. My current workaround is that I export the specifications into PDFs, which don't allow changes, and don't care about people changing the original Excel spreadsheet until the change becomes relevant.

To phrase my question clearly - can I disable Auto-Save feature per document?

3
  • Try this File,, Option,, Save,,, Check Disable Auto-recovery,, un check Save Auto recovery . Apr 29, 2020 at 12:13
  • I need to change settings per document, not per PC.
    – masiton
    Apr 29, 2020 at 12:15
  • Then U need to use VBA macro. Apr 29, 2020 at 12:54

1 Answer 1

0

I have discovered, that Office documents offer number of features hidden under Protect document sub-menu. Microsoft Excel in particular provides number of ways how to tell users that changes in documents are undesired:

enter image description here

Details about this feature are here. This will at minimum notify users that changes shouldn't be made, or will prevent them from making changes altogether.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.