Forum Discussion
Excel opens copy of file every time i click on the file and when i try to save..
I will start from the beginning to make sure you understand:
I right click on the file which is protected
Dialog box for password opens, but this dialog box is for the "copy file"
If I enter the password for the "copy file" it opens a grey blank excel file (print screen below)
After this I close the "copy" grey excel file
Dialog box for the original file opens
I enter the password and is all good...
If I don't enter the password for the copy file, then every time I push "save" I get this dialog box for the copy fie to introduce the password.
- Simply speaking when I double click or right click to open an password protected Excel file, it opens a file and copy of the file...and this is very annoying!
Link:Protection and security in Excel
Notes: Protecting the workbook is not the same as protecting an Excel file or a worksheet with a password. See below for more information:
To lock your file so that other users can't open it, see Protect an Excel file.
To protect certain areas of the data in your worksheet from other users, you have to protect your worksheet. For more information, see Protect a worksheet.
To know the difference between protecting your Excel file, workbook, or a worksheet, see Protection and security in Excel.
Additional Links:
Link:Password Options
Link:How to unprotect the excel sheet if forgot the password
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- Please read my error carefully before replying with entirely different solution..
