It doesn't look like any of these is what the 'Windows Credentials' is after. we have tried entering known sign-ons for the ftp/http server and domain sign-ons and PC sign-ons. With previous versions of Excel there was never a need to enter ANY sign-on. In answer to your question it is only CSV files that we have tried opening (the ftp/http locations only contain CSV files). I should have made the point in my original post that this is happening on more than 1 PC in fact we have a selection of client PCs with different environments ranging from Windows Server 2012 to Windows 7.Īny PC that has been upgraded to Excel 2016 then imediately stops opening CSV files when it had with all previous versions of Excel. Thanks for taking time to look at this issue. If you have feedback for TechNet Support, Emi, Mark the reply as an answer if you find it is helpful. Store passwords, certificates, and other credentials for automatic logon:

In the User name and Password boxes, make sure user name and password is blank.

In the left pane, click Manage your credentials.

Under Password protected sharing, Turn off password protected sharingģ.

Click on Change advanced sharing settings.Make sure you have selected Home group as your active network.Ģ. Then you can try these steps to disable Windows security credentials.ġ. csv file? Did you set any passwords for connecting to the site?įirst I suggest you try to turn off firewall in your environment. If you entered one or both passwords, click “OK,” re-enter the password or passwords when prompted, click “OK” again and then click the “Save” button.Did this issue only appear with. If you want Excel to prompt for write access, enter a password in the “Password to modify:” field.Ĭlick the “OK” button to close the dialog box and then click “Save” to save the file with the changes.

If you want Excel to prompt for a password to open the file, enter a password in the “Password to open:” field. When someone accesses the file, Excel will display a prompt advising the user that the workbook should be opened as read-only unless changes are necessary.Īdd passwords if you want Excel to prompt for a password before allowing a user to open or modify the workbook file.

Click the “File” tab on the ribbon and select “Save As” from the menu to open the Save As dialog box.Ĭlick the “Tools” button and select “General Options” from the drop-down menu to open the General Options dialog box.Ĭlick the box next to the “Read-only recommended” option.

How to put password on excel file 2016