+ Reply to Thread
Results 1 to 3 of 3

Missing (Lost) Tables

  1. #1
    Registered User
    Join Date
    10-11-2017
    Location
    Wisconsin, USA
    MS-Off Ver
    2016
    Posts
    2

    Missing (Lost) Tables

    Has anyone ever seen this before?

    I have an Excel doc open. I close the lid, do some other things and come back about an hour or so later. The Excel doc is still open but all of the tables have disappeared. Like, every. single. table. The data is still there, but the tables are not and the name manager is empty. Which means all my formulas that referenced the tables return errors because the named fields they were referencing have disappeared (replaced by #REF!).

    The document in question is set to auto-save. There is no option to "undo" or "redo" (the tabs are grayed out).

    My version of Office is 2016. My system is Windows 10. I usually leave my laptop on, turning it off about once every two to four weeks, to run updates. When I close the lid, the system is set to "sleep." I've noticed that, occasionally, the system will . . . do something else when I close the lid; I say this because, when I open it up, some of the apps have shut down (like, when I restart the browser, it reopens old tabs).

    I store my documents on the cloud (with a local setting for this one computer) since I have three laptops that I use; this one, a tablet (Surface) and a work computer (which I rarely use to connect to personal files).

    Is there a way to fix this and get the tables back? Or do I have to manually recreate them (and fix the associated functions)?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Missing (Lost) Tables

    Hi, welcome to the forum

    1. I have never heard of this behavior before, nor can I see how excel would suddenly just "lose" tables/data/formulas/anything without some outside intervention (eg someone messing with you, some hidden VBA code running)

    2. If the file has been saved, unless a backup with the :old data" was made at some point, Im afraid you are S.O.L regarding recovery
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-11-2017
    Location
    Wisconsin, USA
    MS-Off Ver
    2016
    Posts
    2
    I thought as much, figured I'd ask just in case.

    Thank you for the feedback.

+ 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. Replies: 3
    Last Post: 07-14-2021, 04:34 PM
  2. Replies: 0
    Last Post: 08-31-2017, 10:40 AM
  3. Copy new workbook lost connection betwenn pivot tables and slicers
    By okat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2017, 11:00 AM
  4. Code List Tables - missing the Linked Tables
    By RxMiller in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2009, 01:13 PM
  5. Pivot Tables lost link
    By Marcos in forum Excel General
    Replies: 0
    Last Post: 05-25-2006, 10:20 AM
  6. FOUND LOST FILE BUT COPY IS MISSING
    By NITRAM RENRAS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-26-2006, 04:10 PM
  7. [SOLVED] Pivot tables lost in Excel 2003
    By [email protected] in forum Excel General
    Replies: 0
    Last Post: 10-04-2005, 08:05 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