+ Reply to Thread
Results 1 to 5 of 5

Missing sheets

  1. #1
    Registered User
    Join Date
    05-16-2016
    Location
    Pensacola, FL
    MS-Off Ver
    Office 2013 updated to version 2015
    Posts
    2

    Missing sheets

    I work for a law firm and we have been using/editing a particular Excel workbook for over five years. I has/had numerous worksheets. After we went through some server/backup changes (may or may not be pertinent) we noticed that some of the older sheets of the workbook (those mainly used/edited in recent years) are missing. All of the ones we currently use are still there.

    I've read about the hidden sheet issues of some but that appears to be an easy fix and usually is all of the sheets. This is about 30 out of 50 sheets that just vanished.

    Any thoughts on this?

    I have Office 2013 that has been updated to version 15.0.4815.1002.

    Thanks for any help/insight.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Missing sheets

    If they haven't been just regular "hidden" two possible alternatives are "very hidden" where they will not show up when right clicking on a tab at the bottom- you need VBA and their exact names to unhide them. Or they were deleted.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Missing sheets

    Hello & Welcome to the Forum,

    Another way, open up the VBE (Alt + F11) and see if those sheets are in the VBAProject for that book.

    If they are, you can use the Properties Windows to select the Visible property and change to xlSheetVisible.

    View >> Properties Window (or F4)

    If they are not in the VBE VBAProject then they are gone.

    Reference
    HTH
    Regards, Jeff

  4. #4
    Registered User
    Join Date
    05-16-2016
    Location
    Pensacola, FL
    MS-Off Ver
    Office 2013 updated to version 2015
    Posts
    2

    Re: Missing sheets

    Success! Found the hidden sheets and marked them to be visible. I appreciate your time and help.

  5. #5
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Missing sheets

    You are very welcome. We are happy to help!

+ 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. Missing Sheets After Download
    By singerr45 in forum Excel General
    Replies: 9
    Last Post: 03-16-2016, 03:36 PM
  2. VBA to find missing items between 4 sheets and name sheets that have and not
    By asafebass in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2016, 09:47 AM
  3. Sheets are missing and so are additional cells
    By mabowers in forum Excel General
    Replies: 5
    Last Post: 11-17-2014, 12:09 AM
  4. look for missing numbers between sheets
    By mingali in forum Excel General
    Replies: 8
    Last Post: 02-27-2010, 03:39 AM
  5. Find what names are missing in sheets
    By magicool in forum Excel General
    Replies: 6
    Last Post: 02-21-2010, 11:48 AM
  6. Sheets Missing From Reference
    By chromics in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2009, 02:37 PM
  7. Sheets missing
    By Andy in forum Excel General
    Replies: 2
    Last Post: 05-19-2005, 07:06 AM

Tags for this Thread

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