Cannot Add New Worksheet in Workbook

User avatar
BobH
UraniumLounger
Posts: 9218
Joined: 13 Feb 2010, 01:27
Location: Deep in the Heart of Texas

Cannot Add New Worksheet in Workbook

Post by BobH »

Although I have no idea what, I've apparently done something to one of my Excel (Office 2016 I think) workbooks. The click button to add a worksheet is greyed out. From searching, it appears that there is no limit on then number except the amount of memory one has. Neither the workbook nor the active worksheet is protected.

Can someone please tell me what I've done and how to fix it?


:cheers: :chocciebar: :thankyou:

Again, I apologize for wasting bandwidth. The workbook was apparently protected although the Review tab did not reveal it to by so by giving an 'unprotect' option. I clicked on the menu choice to protect the workbook and entered the password I use for protecting them and was then able to add a worksheet.

Here's the ss of my Review options before I made any changes.
Excel Worksheet Review Protection.PNG
You do not have the required permissions to view the files attached to this post.
Last edited by BobH on 21 May 2023, 20:09, edited 1 time in total.
Bob's yer Uncle
(1/2)(1+√5)
Intel Core i5, 3570K, 3.40 GHz, 16 GB RAM, ECS Z77 H2-A3 Mobo, Windows 10 >HPE 64-bit, MS Office 2016

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Cannot Add New Worksheet in Workbook

Post by HansV »

Can you post a screenshot of the Protect group of the Review tab of the ribbon in that workbook?
Best wishes,
Hans

User avatar
BobH
UraniumLounger
Posts: 9218
Joined: 13 Feb 2010, 01:27
Location: Deep in the Heart of Texas

Re: Cannot Add New Worksheet in Workbook

Post by BobH »

I was in the process as you were posting, Hans! Thanks for the offered help.
Bob's yer Uncle
(1/2)(1+√5)
Intel Core i5, 3570K, 3.40 GHz, 16 GB RAM, ECS Z77 H2-A3 Mobo, Windows 10 >HPE 64-bit, MS Office 2016

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Cannot Add New Worksheet in Workbook

Post by HansV »

It's confusing - the caption of the Protect Sheet button changes to Unprotect Sheet when the sheet is protected, but the caption of the Protect Workbook button does not change when the workbook is protected. Instead, the button is highlighted.

(Also see this post...)
Best wishes,
Hans

User avatar
BobH
UraniumLounger
Posts: 9218
Joined: 13 Feb 2010, 01:27
Location: Deep in the Heart of Texas

Re: Cannot Add New Worksheet in Workbook

Post by BobH »

It's way to easy to confuse me these days. :laugh:
Bob's yer Uncle
(1/2)(1+√5)
Intel Core i5, 3570K, 3.40 GHz, 16 GB RAM, ECS Z77 H2-A3 Mobo, Windows 10 >HPE 64-bit, MS Office 2016