Can you recover crashed Excel 2013 file with a file that begins with ~$ ? RRS feed

  • Question

  • My Excel 2013 (Windows 10) suddenly crashed and rebooted. When it did, it had an earlier timestamp than I recall last saving. I noticed a file with same name and extension in the same folder and a more accurate modified timestamp to what I had thought to have last saved -- except that it begins with "~$xxxxxxx.xlsm" Is it possible to recover anything from this?

    Newbie enough to get myself into trouble. :0) Eyes are crossed and growth is pain ... but working on it.

    • Edited by GeneralB Wednesday, January 17, 2018 12:50 AM grammarly plugin keeps adding <bracket text>
    • Moved by Dave PatrickMVP Wednesday, January 17, 2018 2:08 AM
    Wednesday, January 17, 2018 12:42 AM


All replies

  • I made a copy of the ~$...xlsm file and changed end to .csv. It opened but only two cells of text showed. Just moved forward from the earlier save, but am still curious if a solution involving the ~$ file exist. If anyone knows this answer, would like to hear.

    Newbie enough to get myself into trouble. :0) Eyes are crossed and growth is pain ... but working on it.

    Wednesday, January 17, 2018 1:51 AM
  • I'd ask for help over here with possible recovery.




    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    Wednesday, January 17, 2018 2:07 AM
  • Hi,

    An Office file which begins with "~$" is a temporary file (usually hidden). It will be created and deleted automatically by Office application (Excel, Word, and so on). I'm afraid you cannot repair from it.

    Please try to repair your Excel file: Repair a corrupted workbook

    # After you can repair your file(s), please think about why/when Excel 2013 crashed. Otherwise it may be occur again. 



    Wednesday, January 17, 2018 3:23 AM