topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Friday March 29, 2024, 7:52 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: H E L P !!! I lost a spreadsheet!  (Read 11134 times)

CodeTRUCKER

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 1,085
    • View Profile
    • Donate to Member
H E L P !!! I lost a spreadsheet!
« on: January 12, 2008, 01:42 AM »
I closed my spreadsheet and never saved it and for some unknown reason when the dialog came I chose close without saving. 

Is there a way to get that file back?  Is there a temporary hiding somewhere?

TIA!
« Last Edit: May 12, 2009, 08:02 PM by CodeTRUCKER »

PhilB66

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 1,522
    • View Profile
    • Donate to Member
Re: H E L P !!! I lost a spreadsheet!
« Reply #1 on: January 12, 2008, 03:57 AM »
Try in Documents and Settings\User Name\Application Data\Microsoft\Excel\

Oh, wait... just found this...

"Excel automatically saves every 10 minutes to the default location of "C:\ Documents and Settings\<username>\Local Settings\Temp" The files are identifiable as they are saved as a number .tmp e.g. "28.tmp". This means that they look different from word or any other temporary files that are being saved there by other applications."

(Source Recovery of MS Office Files from Temp Files)
« Last Edit: January 12, 2008, 04:03 AM by PhilB66 »

CodeTRUCKER

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 1,085
    • View Profile
    • Donate to Member
Re: H E L P !!! I lost a spreadsheet!
« Reply #2 on: January 12, 2008, 11:16 AM »
No dice.  There is nothing there that I can find.  Thanks for trying.
« Last Edit: May 12, 2009, 08:04 PM by CodeTRUCKER »

PPLandry

  • Supporting Member
  • Joined in 2007
  • **
  • Posts: 702
    • View Profile
    • InfoQube Information manager
    • Read more about this member.
    • Donate to Member
Re: H E L P !!! I lost a spreadsheet!
« Reply #3 on: January 12, 2008, 09:59 PM »
I closed my spreadsheet and never saved it and for some unknown reason when the dialog came I chose close without saving. 

Is there a way to get that file back?  Is there a temporary hiding somewhere?

TIA!
If the file was opened from an email client, it is saved in a temp folder. It should stay there quite some time.

If you created it, and true backups are not enabled (file>save as>tools>general options: for 2002 at least), you can't use the backup referenced earlier. That one in only in case of crash. It is deleted on file>close.

After all these years of pseudo word and excel integration, the two behave so differently  :down: backup management is just one example of this.  >:( :down:
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz
« Last Edit: January 12, 2008, 10:03 PM by PPLandry »

lanux128

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 6,277
    • View Profile
    • Donate to Member
Re: H E L P !!! I lost a spreadsheet!
« Reply #4 on: January 13, 2008, 04:14 AM »
i once made an AHK script for a friend as he kept running into situations like this. assuming you use Microsoft Excel, maybe you'll find it useful too.. :) this script monitors and disables the "No" button in the dialog box that prompts up when trying to close an unsaved file. (see pic).

ws-disabler-1.png

P.S. in case you really need to close a file without saving, there is a hotkey (Win+p) that will turn off the monitoring for 10 seconds.

* No_Unsaved.ahk (0.53 kB - downloaded 426 times.)

jgpaiva

  • Global Moderator
  • Joined in 2006
  • *****
  • Posts: 4,727
    • View Profile
    • Donate to Member
Re: H E L P !!! I lost a spreadsheet!
« Reply #5 on: January 13, 2008, 08:19 AM »
LOL lanux!

Now that's something i'd never think, but it sure looks useful.

[edit] typo :) [/edit]
« Last Edit: February 12, 2008, 03:08 AM by jgpaiva »

lanux128

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 6,277
    • View Profile
    • Donate to Member
Re: H E L P !!! I lost a spreadsheet!
« Reply #6 on: January 13, 2008, 06:10 PM »
Now that's something i'd never thing, but it sure looks useful.

jgpaiva: you'll be surprised how many people find that confusing, "save the changes" is like more like making the changes permanent.. imo, it should be "do you want to close <document_name> without saving?". :)

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: H E L P !!! I lost a spreadsheet!
« Reply #7 on: February 12, 2008, 02:38 AM »
nice idea!!