<div>
Is the password the standard Excel protection or is it generated by a macro?
</div>


Is the password the standard Excel protection or is it generated by a macro?

<div>
HI, it's a standard excel password...
</div>


<div>
Hi Bharat, it is happening for the user with both .xls and .xlsx files...
</div>


Hi Bharat, it is happening for the user with both .xls and .xlsx files...

<div>
As per question, when user entering the password in Excel 2007 and, it is working fine. The password showing blank in Excel 2016. How do you copy from one system to another?
</div>


As per question, when user entering the password in Excel 2007 and, it is working fine. The password showing blank in Excel 2016. How do you copy from one system to another?

<div>
Hi - Excel 2016 is on his laptop. Excel 2007 is on a terminal server which the user also accesses.
</div>


Hi - Excel 2016 is on his laptop. Excel 2007 is on a terminal server which the user also accesses.

<div>
<div class="content wysiwyg-content">
HI<br />
<br />
A user opens a password protected excel spreadsheet in Excel 2007 and he enters password and accesses spreadsheet no problem.<br />
<br />
When he opens the same spreadsheet from a different system which is running Excel 2016, the password field remains blank even when he enters characters, and he cannot access it as a result.<br />
<br />
Any ideas?!
</div>
</div>


HI

A user opens a password protected excel spreadsheet in Excel 2007 and he enters password and accesses spreadsheet no problem.

When he opens the same spreadsheet from a different system which is running Excel 2016, the password field remains blank even when he enters characters, and he cannot access it as a result.

Any ideas?!

Cannot enter password in protected spreadsheet to access it

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.