Join Now OfficeExcelWin10 Not one particular file that I'm having trouble with, but basically any Excel file that I open is randomly subject to the issue. This prevents other users from opening the file. Which level of protection should I use? For more information, see Add or remove protection in your document, workbook, or presentation.
You can later share the appropriate passwords with the team depending on the access they should be given. You can always ask an expert in the Excel Tech Communityget support in the Answers communityor suggest a new feature or improvement on Excel User Voice.
Many business owners and administrators prefer this option as it helps protect original workbook files and templates from permanent changes. In order to save my work I have to save with a different name, and after that everything resets and I am free to save over the original file.
See Also. You can protect the Excel file by specifying two passwords: one to open, and the other to modify. For more information, see Add or remove a digital signature in Office files.
To control how users should work within an individual worksheet, use worksheet-level protection. Not an everyday issue, but there are days where it happens several times throughout the day, with no rhyme or reason.