Solved

File recovery questions

Posted on 2011-02-22
9
329 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
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.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Sometimes we receive PDF files that are in the wrong orientation. They may be sideways or even upside down. This most commonly happens with scanned or faxed documents. It is possible to rotate the view of these PDFs with the free Adobe Reader produc…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

830 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