Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account


Photo

options to recover deleted sheets within an excel file?

- - - - -

  • Please log in to reply
2 replies to this topic

#1
office13broken

office13broken

    Newbie

  • Member
  • 25 posts
  • Joined 27-April 13
  • OS:none specified
  • Country: Country Flag
what are the options to recover deleted sheets within an excel file? nothing in the recycle bin

excel file isnt in \AppData\Roaming\Microsoft\Excel

autosave is set to 120 mins though it should have saved at least once...


How to remove advertisement from MSFN

#2
office13broken

office13broken

    Newbie

  • Member
  • 25 posts
  • Joined 27-April 13
  • OS:none specified
  • Country: Country Flag

does anybody know??



#3
CharlotteTheHarlot

CharlotteTheHarlot

    MSFN Master

  • Member
  • PipPipPipPipPipPipPipPip
  • 2,054 posts
  • Joined 24-September 07
  • OS:none specified
  • Country: Country Flag
What version of Excel?

I don't recall deleted "worksheets" (tabs within a workbook) ever appearing in the recycle bin. They appear to only exist in memory and when deleted are gone from that instance in memory and then from the currently open XLS file once you click save. In other words, you could delete a worksheet and then close Excel WITHOUT saving the file and that deleted sheet would still exist if you reopen that XLS.

Once you save the XLS though, that sheet is gone for good, unless you have a lucky copy ( probably with a $ first character ) in the same folder from some special set of circumstances.

Search the entire HDD for the filename WITHOUT extension and WITHOUT the first character. Example: for Workbook.xls search for orkbook

... Let him who hath understanding reckon the Number Of The Beast ...





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users



How to remove advertisement from MSFN