Share via

can't add tab in Excel

Anonymous
2017-11-21T18:25:26+00:00

I'm using Microsoft Office365 ProPlus Version 1710 Build 8625.2121 Click to Run on Windows 10 Pro 10.0.15063 N/A Build 15063.

I have an Excel file that I can't see the hidden tabs and I can't add a tab because the "+" is stippled out. Previous versions of this file are fine. I am not the only one that uses this file. the other users are not administrators, I am.

The attachment shows what I'm seeing 

Any help would be appreciated.

Thanks

Sam

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2017-11-22T15:22:59+00:00

    Hi Sam,

    Go to Review tab > Protec > Protect workbook to check if there’s any password set for protecting this workbook.

    If the workbook is not protected, try the steps below to see the result:

    1. Save as the workbook. Check the new copy of the workbook.
    2. Copy worksheet from this workbook to a new created one.

    Thanks,

    Rena

    12 people found this answer helpful.
    0 comments
Answer accepted by question author
  1. Anonymous
    2017-11-24T22:09:51+00:00

    Hi Sam,

    Have you tried the steps above?

    Thanks,

    Rena

    2 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-11-21T18:27:19+00:00

    One more thing, I've asked one of the other administrators to see if they can open the hidden tabs or add a tab from their machine and they are unable to so this is not a problem that is related to the machine or the version of Excel

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2017-11-21T19:05:29+00:00

    Hi Sam,

    Based on your description, you have issue that can’t add/hide/unhide worksheets. And the issue only happens to this specific workbook.

    Refer to Hide or show worksheets or workbooks, we would like to confirm that does this workbook contain VBA code? If worksheets are hidden by Visual Basic for Applications (VBA) code that assigns the property xlSheetVeryHidden, you cannot use the Unhide command to display those hidden sheets. If you are using a workbook that contains VBA macros and you encounter problems when working with hidden worksheets, contact the owner of the workbook for more information.

    Please also check whether you have protected this workbook via Review>Protect>Protect Workbook. As you cannot hide or unhide sheets in a protected workbook.

    Thanks,

    Rena

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2017-11-21T19:53:45+00:00

    Thanks for the quick response. To answer your questions:

    • I know how to hide and show tabs as witnessed by the attachment so that isn't the issue
    • There is no VBA code in the spreadsheet. The only thing that I'm doing is importing data via the ribbon Data->Get Data / Queries and & Connections. This is something I'm doing in all versions of this workbook so that isn't the problem because I can add tabs and access the hidden tabs in the other versions
    • There is protection being used in this workbook (and all previous versions) but on cells in each tab and not on the whole workbook
    • Not sure where to find Review->Protect->Protect Workbook
    0 comments