|
|
|
|||||||
| FlashChat | Actuarial Discussion | Preliminary Exams | CAS/SOA Exams | Cyberchat | Around the World | Suggestions |
D.W. Simpson and Company -- Actuary Salary
Surveys |
 |
|
|
Thread Tools | Display Modes |
|
#1
10-30-2002, 04:29 PM
|
||||
|
||||
Recovering from a 'Save As...' in Excel
Is there anyway to retrieve the original file if you mistakenly 'Save As... 'over it in Excel? I'm fairly certain the answer is no, but just checking.
|
|
#2
10-30-2002, 04:32 PM
|
||||
|
||||
|
I assume you don't have a back up copy on disk, and it wasn't on a company shared drive which they usually back up daily.
__________________
"I've been through the desert on a horse with no name... In the desert you can remember your name 'Cause there ain't no one for to give you no pain"
|
|
#3
10-30-2002, 04:32 PM
|
||||
|
||||
|
Probably not through Excel itself, but possibly through your network system. Try going to the file in Windows Explorer and right-clicking on the folder that contains it. You may see an option to "salvage files" or some such. I know that's saved my bacon a few times.
(Unless you were on a local drive - which would mean you're probably scrod.)
|
|
#5
11-07-2002, 12:50 PM
|
|||
|
|||
|
Quote:
The main motto of a programmer - "backup, backup, backup". Actuaries (everybudy who work with computers) must borrow it.
|
|
#6
12-23-2002, 04:43 PM
|
|||
|
|||
|
You can get back the file you saved over. Bring up a DOS prompt.
Type in the letter of the drive the file is/was located at - e.g. "S:" Hit Enter Type in: "cd" then the path of the folder the file was saved in, e.g. "cd s:\excel files\stupid deletion\" Hit Enter Type the DOS function "filer" and hit enter. Select "Salvage Deleted Files", then "View/recover deleted files", then type in the extension of the file you deleted or saved over, e.g. ".xls", then just select the version of the file you want to restore based on the date/time stamp. This may not work for you anymore, not sure when you originally posted this, but keep these instructions around. This has saved me hours and hours of time since I learned this trick!
|
|
#7
12-23-2002, 04:50 PM
|
|||
|
|||
|
Coach, I think you've got some proprietary software running on your system. To the best of my knowledge, filer is not a plain-vanilla DOS command.
|
|
#8
12-23-2002, 05:07 PM
|
||||
|
||||
|
Quote:
__________________
Don't listen to a word I say. The screams all sound the same.
|
|
#9
12-23-2002, 05:14 PM
|
|||
|
|||
|
I didn't know anybody still ran Netware. (Nor did I know filer was a Netware command.)
|
|
#10
12-24-2002, 12:42 PM
|
||||
|
||||
|
Quote:
Oh, yeah. Filer IS a DOS based utility in Netware. See http://www.ohsu.edu/helpdesk/net/filer2.shtml Brad
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
