jimbob
Offline
Posts: 1429
|
|
« on: Monday, December 7, 2009, 20:06:14 » |
|
think Ive had a mare spent best part of 5 hours updating a spreadsheet on sat and went to go back into it today but it dont appear to have saved the changes. I went into an old email I sent thru hotmail to find the said document, and opened it, done what I needed to adding new tabs etc...and continually clicking save as wanted to be certain that I had saved it (feeling all smug as i went, happy to be getting the chore over with).... tried going in thru recent docs and into the old email but cant find the saved copy anywhere.... please help
|
|
|
Logged
|
|
|
|
Bogus Dave
Ate my own dick
Offline
Posts: 16348
|
|
« Reply #1 on: Monday, December 7, 2009, 20:08:41 » |
|
Have you tried trurning it off and turning it on again?
|
|
|
Logged
|
Things get better but they never get good
|
|
|
jimbob
Offline
Posts: 1429
|
|
« Reply #2 on: Monday, December 7, 2009, 20:11:48 » |
|
Have you tried trurning it off and turning it on again?
one thinks u might be taking the piss
|
|
|
Logged
|
|
|
|
Batch
Not a Batch
Online
Posts: 55294
|
|
« Reply #3 on: Monday, December 7, 2009, 20:15:23 » |
|
So you are saying it's not in the recent document list under Excels File menu then?
Two things I can think of:
1. Look under the tools/options menu in excel to see where the default file path is (shown in the "general" tab in excel 2003). Check the files in that location. 2. Search for all files (or *.xls files) modified on/after a date (i.e. Saturday).
If you opened it from an email it may be in a temp directory somewhere???
|
|
|
Logged
|
|
|
|
Ginginho
Offline
Posts: 6853
|
|
« Reply #4 on: Monday, December 7, 2009, 20:17:24 » |
|
If you opened it from an email it may be in a temp directory somewhere???
I reckon it's this. Open up the attachment from the email again, go to file, save as and it should take you to the temp folder where it's saved.
|
|
|
Logged
|
|
|
|
Bogus Dave
Ate my own dick
Offline
Posts: 16348
|
|
« Reply #5 on: Monday, December 7, 2009, 20:17:34 » |
|
Ctrl+Alt+Delete??
|
|
|
Logged
|
Things get better but they never get good
|
|
|
Batch
Not a Batch
Online
Posts: 55294
|
|
« Reply #6 on: Monday, December 7, 2009, 20:19:53 » |
|
I reckon it's this.
Open up the attachment from the email again, go to file, save as and it should take you to the temp folder where it's saved.
But don't actually save it over the top of your edited copy!
|
|
|
Logged
|
|
|
|
Barry Scott
Offline
Posts: 9112
|
|
« Reply #7 on: Monday, December 7, 2009, 20:21:51 » |
|
Yeah, sounds like you've been working from the attachment without saving it locally, so should be in your temp files as Ginginho said.
|
|
|
Logged
|
|
|
|
Dozno9
|
|
« Reply #8 on: Monday, December 7, 2009, 20:37:48 » |
|
If the original document was in an email it may be saved within the OLK folder.
|
|
|
Logged
|
|
|
|
jimbob
Offline
Posts: 1429
|
|
« Reply #9 on: Monday, December 7, 2009, 20:40:52 » |
|
when I do the old save as, it simply takes me to the 'my documents' folder but it aint there.....what next please folks?? and what the OLK folder?
the spreadsheet was in my hotmail account so not sure if this makes a difference??
|
|
|
Logged
|
|
|
|
Dazzza
Offline
Posts: 8265
|
|
« Reply #10 on: Monday, December 7, 2009, 20:57:35 » |
|
Have a gander in:
"C:\ Documents and Settings\<username>\Application Data\Microsoft".
If the file is stored on a network drive then it will be temporarily created there.
It will look something like:
~dfxxxx.tmp
Or if you had autosave on have a gander in here:
C:\ Documents and Settings\<username>\Local Settings\Temp
It will be an .tmp file although Autosave isn't always on by default in Excel
|
|
|
Logged
|
|
|
|
jimbob
Offline
Posts: 1429
|
|
« Reply #11 on: Monday, December 7, 2009, 21:38:50 » |
|
still no joy....fuck fuck fuckity fuck....
any last chance saloon ideas please? before I throw my laptop thru my front window...me, drama queen?! never
|
|
|
Logged
|
|
|
|
Dazzza
Offline
Posts: 8265
|
|
« Reply #12 on: Monday, December 7, 2009, 21:46:19 » |
|
Very long shot but try a search of the old hard drive using *.xls and *.TMP and see if it crops up in the search. Sort by date to filter out the older stuff.
|
|
|
Logged
|
|
|
|
jimbob
Offline
Posts: 1429
|
|
« Reply #13 on: Monday, December 7, 2009, 22:42:17 » |
|
right, i searched under files modified on 5/12/09 and there are loads ranging from 1 KB to 32,326 KB(guessing thats because I was continually hitting 'save'??) under 'types' some are DAT files, some are PBV, some are KDC, there is one TMP file thats 32,326KB....and the list goes on...its not really clear to me which one I need to try and retrieve.... when I tried opening the largest one, it then asked me what program I needed to retrieve to open it and when I used the excel application, it opened excel but didn't revert to my spreadsheet.... any suggestions welcome....other than from u STFC dave
|
|
|
Logged
|
|
|
|
Crozzer
Offline
Posts: 2487
|
|
« Reply #14 on: Monday, December 7, 2009, 23:38:56 » |
|
If there is a word or two that might be in the Excel file in not anything else, perhaps a search in "Word or Phrase in the File" in the Search menu with the dog. Under "More Advanced Options" tick the boxes "Search System Folders", "Search Hidden Folders" and "Search Subfolders".
Have you had a look in your recycle bin (I am trying to think of a Tiger Woods joke at the mo).
|
|
|
Logged
|
|
|
|
|