Last Updated: December 15, 2021
ISSUE
You cannot change the structure of your workbook, such as re-ordering or adding sheets if you have a reference to an external Excel (.xlsb) Binary File Format workbook that is protected. This will cause your workbook to adopt the structure protection from the external Excel (.xlsb) Binary File Format workbook.
This issue started in Office Version 2110 (Build 14517.20000).
STATUS: FIXED
This issue has been fixed. To apply the fix, update Office by following the steps listed here: Install Office updates
: For any of your Excel workbooks that have been affected, you will need to unlock them. You can unlock the affected Excel workbooks by using the password for the external Excel (.xlsb) Binary File Format workbook they referenced.
More Resources
Ask the experts
Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.
Get help in the community
Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.
Suggest a new feature
We love reading your suggestions and feedback! Share your thoughts. We're listening.
