Solved

File recovery questions

Posted on 2011-02-22
9
328 Views
Last Modified: 2012-05-11
I had a couple users on a Citrix server who were kicked off and lost unsaved work. Both Excel and Adobe are both setup to autosave but neither user was prompted to autorecover their work.

So, my questions are..

1. I see a file one user was working on and it reads ~$filename.xlsx but it won't allow me to open and save the file (unrecognizable format). Is there a trick I might be ble to use to get the information.

2. The other user was working in adobe. Is there a location and/or file type I can search for if it was autosaved? I did a search for the filename but nothing came up? While the document wasn't changed she did lose a bunch of markups she did that she'd like to get back.

0
Comment
Question by:dak11
  • 4
  • 3
  • 2
9 Comments
 
LVL 30

Assisted Solution

by:SiddharthRout
SiddharthRout earned 125 total points
ID: 34957234
Few things that you can try.

1)
Rename the file ~$filename.xlsx and then open it. OR
Do not directly open the file. First open Excel and then from the File ~~> Open try opening it.

2) Not sure about Adobe.

Sid
0
 

Author Comment

by:dak11
ID: 34957249
Thanks, already tried that with Excel.
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34957270
Can you upload the file?

Sid
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 45

Expert Comment

by:patrickab
ID: 34959695
dak11,

In the file Open dialogue box in Excel, at the right hand end of the Open button is a dropdown arrow. Having selected the file to Open, click the dropdown arrow and select Open and Repair. That might do the trick. If not then try using Open Office to open the file and then save it in an Excel format. Open office can be obtained free from:

http://www.openoffice.org/

BTW is the Excel file used in Shared mode. In other words can more than one person use the file at the same time?

Patrick
0
 

Accepted Solution

by:
dak11 earned 0 total points
ID: 34960170
I can't upload the file since it could contain client information.

The file was in use by the user and I've been trying to pull the file from a shadow copy that ran only a few minutes before. The Shadowcopy has the 'in use' file and that's the one I'm trying to open.

I tried the open and repair option in Excel but I'll download and try open office to see if that works.

I do not believe the file is setup for shared use.
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34960379
I think Open Office method mentioned by Patrick will do the trick. However if it doesn't, then try this.

Rename the file ~$filename.xlsx to TempExcel.ZIP. Now open the file using winzip. Does it open? If yes, then post a screen shot of the winzip window.

Sid
0
 

Author Comment

by:dak11
ID: 35021258
Nothing worked. Thanks for the attempt guys.
0
 
LVL 45

Expert Comment

by:patrickab
ID: 35021881
If the Excel file(s) were 'shared' then they are probably corrupted. In  which case the chances of you fully revovering the data in the file(s) is slim.

Patrick
0
 

Author Closing Comment

by:dak11
ID: 35067653
File still not opening.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

#Citrix #XenApp #Citrix Scout #Citrix Insight Services #Microsoft VMMAP #Microsoft ADEXPLORE #Microsoft RAMMAP #Microsoft TCPVIEW #Microsoft AUTORUNS #Microsoft PROCESS EXPLORER #Microsoft PROCESS MONITOR
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question