+ Reply to Thread
Results 1 to 4 of 4

All tabs disappeared!

  1. #1
    Registered User
    Join Date
    12-10-2019
    Location
    Nova Scotia, Canada
    MS-Off Ver
    365
    Posts
    2

    All tabs disappeared!

    I have a large Excel 2013 spreadsheet with 20 tabs, and some very simple data and some graphs.

    This spreadsheet is edited every monday by several people as they enter their department's weekly summary data.

    Yesterday when I opened the spreadsheet and all the tabs were gone. There was not even a blank tab, just a blank area under the ribbon/menus.

    The small amount of VBA code in this file is still visible.

    This has happened 2 or 3 times before over the last few years. When it happens, I retrieve a recent backup and ask people to look up their last couple weeks' data to re-enter.

    The file size is the same as before. I suspect that all the information for each of the tabs is still stored in the file, but for some reason it won't/can't display the tabs.

    Just wondering if anyone know what causes this problem, and if there is a way to force it to show the tabs that I believe are still there.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: All tabs disappeared!

    have you tried any/all of these??

    https://support.office.com/en-gb/art...c-f1b381185e48
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    Re: All tabs disappeared!

    If Unhide is enabled on the View tab, use that to unhide the workbook.
    Rory

  4. #4
    Registered User
    Join Date
    12-10-2019
    Location
    Nova Scotia, Canada
    MS-Off Ver
    365
    Posts
    2

    Re: All tabs disappeared!

    It was hidden under the View menu. Thank you both.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. It Disappeared!
    By NanC29 in forum The Water Cooler
    Replies: 1
    Last Post: 08-13-2011, 10:21 PM
  2. UDF disappeared
    By deadpickle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2011, 11:35 AM
  3. gridlines have disappeared
    By Ronn62 in forum Excel General
    Replies: 13
    Last Post: 10-30-2008, 07:40 AM
  4. [SOLVED] All the cells have disappeared!!
    By David Anderson in forum Excel General
    Replies: 2
    Last Post: 03-22-2006, 02:25 PM
  5. Worksheet has disappeared
    By frankybenali in forum Excel General
    Replies: 2
    Last Post: 02-01-2006, 11:15 AM
  6. [SOLVED] Add-in disappeared
    By fiona in forum Excel General
    Replies: 2
    Last Post: 02-10-2005, 08:06 PM
  7. Tabs in my workbook disappeared when sent via email
    By squeesan in forum Excel General
    Replies: 0
    Last Post: 01-22-2005, 12:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1