Recovery file???

J

John Holt

Hello all,

I upgrade my MS Office from 2003 to 2007. Opened an Excel file and saved it
as a new workbook. Now I have this hidden file with the name of my file
preceeded with ~$ and xlsx extension that refuses to go away. If I delete
it, it appears to go away then as soon as I refresh, it's back. My files are
in my data folder on a network drive. The file is NOT open. My workstation
has been re-booted but the server with the user data files has not.

Anyone know how I can get rid of that file WITHOUT re-booting my server???

Thanks,
John
 
D

Dave Peterson

This is not something that excel does.

But it sounds suspiciously like what MSWord does.

Could that file have been opened in MSWord by mistake.

It should disappear when the user closes the file normally. I've never seen
these files fail to be deleted--if the file is not open in MSWord.

Can you ask the IT help desk for some help?
 
J

Jim Rech

Actually this does seem to be the new way that Excel 2007 tracks open files.
What happens if you save an new empty workbook with the same name as the
hidden file (minus the ~$ of course)? And then close it. I wonder if Excel
would connect them?

--
Jim
| Hello all,
|
| I upgrade my MS Office from 2003 to 2007. Opened an Excel file and saved
it
| as a new workbook. Now I have this hidden file with the name of my file
| preceeded with ~$ and xlsx extension that refuses to go away. If I delete
| it, it appears to go away then as soon as I refresh, it's back. My files
are
| in my data folder on a network drive. The file is NOT open. My
workstation
| has been re-booted but the server with the user data files has not.
|
| Anyone know how I can get rid of that file WITHOUT re-booting my server???
|
| Thanks,
| John
|
 
J

John Holt

Thanks for the reply Jim,
No, it didn't connect them. Saved the file just fine though.:)
I'm sure it will go away when I re-boot the server. Sure would be nice not
to have to do that though.
 
D

Dave Peterson

Oops. Thanks for the correction, Jim.

I'll stay away from these pesky xl2007 questions.
 
D

Dave Peterson

Do you think the file is locked and is failing to be deleted or do you think the
file is being recreated by something?

Does the date accessed/modified/created change?

There are some free utilities that will delete files even if they're locked.

I've never used these (on a local drive or on a network drive), but you may want
to look at these:

http://lifehacker.com/software/feat...p-has-locked-a-file-with-wholockme-267243.php

http://lifehacker.com/software/how-to/delete-a-locked-file-in-windows-266433.php

If either help, please post back.

Even though I don't know what I'm saying with xl2007, I'm still curious.
 
J

Jim Rech

I'll stay away from these pesky xl2007 questions.

Now that's not the 'take away' here, Dave<g>.

I'd like to understand the new temp files better though. Unlike XLS files
XLSX files do not get re-date stamped temporarily when opened but the temp
file appears. So it seems that the temp file is now the marker that the
file is open. However if you create an artificial temp file ahead of time
(a ~$Book1.xlsx) and open Book1.xlsx Excel 2007 doesn't object and it
doesn't create a temp file. But it doesn't use the artificial temp file
either because you can delete it (unlike a real one) with Book1.xlsx still
open.

But here's the mystery, if you do delete the bogus temp file and then open
Book1.xlsx in another instance of Excel it tells you "another user" has it
open. How does it know that? And if it knows it without the temp file what
is the temp file for? There, now you know everything I know, which ain't
much<g>.
 
B

Bruce Sinclair

Now that's not the 'take away' here, Dave<g>.

I'd like to understand the new temp files better though.

Sounds like a good idea ... but surely MS has published this information
somewhere haven't they ? Assuming they have, wouldn't it be more useful to
get the data than speculate ? ... as fun as that is of course. :)
 
D

Dave Peterson

The real take-away may be to actually start using xl2007 <vvbg>. (But learning
something new hurts soooo much!)

Anyway...

I start up VPC and xl2007. Then I created a book1.xlsx and saved it onto my
desktop. Fiddled with the windows setting to see those hidden files.

The book1.xlsx is abou 7kb. The ~$Book1.xlsx is 165 bytes.

The onliest(!) way I could open this bleeping file was to kill excel/windows. I
didn't have anything that could open the file while it was in use.

But it looks like it just contains the username and the username characters
separated by x00's.
 
J

Jim Rech

But it looks like it just contains the username

You'd then think a second instance of Excel would report the name of the
person (me) who has the file open rather than 'another user'. Maybe it's a
bug<g>.

--
Jim
| The real take-away may be to actually start using xl2007 <vvbg>. (But
learning
| something new hurts soooo much!)
|
| Anyway...
|
| I start up VPC and xl2007. Then I created a book1.xlsx and saved it onto
my
| desktop. Fiddled with the windows setting to see those hidden files.
|
| The book1.xlsx is abou 7kb. The ~$Book1.xlsx is 165 bytes.
|
| The onliest(!) way I could open this bleeping file was to kill
excel/windows. I
| didn't have anything that could open the file while it was in use.
|
| But it looks like it just contains the username and the username
characters
| separated by x00's.
|
|
|
|
|
| Jim Rech wrote:
| >
| > >>I'll stay away from these pesky xl2007 questions.
| >
| > Now that's not the 'take away' here, Dave<g>.
| >
| > I'd like to understand the new temp files better though. Unlike XLS
files
| > XLSX files do not get re-date stamped temporarily when opened but the
temp
| > file appears. So it seems that the temp file is now the marker that the
| > file is open. However if you create an artificial temp file ahead of
time
| > (a ~$Book1.xlsx) and open Book1.xlsx Excel 2007 doesn't object and it
| > doesn't create a temp file. But it doesn't use the artificial temp file
| > either because you can delete it (unlike a real one) with Book1.xlsx
still
| > open.
| >
| > But here's the mystery, if you do delete the bogus temp file and then
open
| > Book1.xlsx in another instance of Excel it tells you "another user" has
it
| > open. How does it know that? And if it knows it without the temp file
what
| > is the temp file for? There, now you know everything I know, which
ain't
| > much<g>.
| >
| > --
| > Jim
| > | > > Oops. Thanks for the correction, Jim.
| > >
| > > I'll stay away from these pesky xl2007 questions.
| > >
| > > Jim Rech wrote:
| > >>
| > >> Actually this does seem to be the new way that Excel 2007 tracks open
| > >> files.
| > >> What happens if you save an new empty workbook with the same name as
the
| > >> hidden file (minus the ~$ of course)? And then close it. I wonder
if
| > >> Excel
| > >> would connect them?
| > >>
| > >> --
| > >> Jim
| > >> | > >> | Hello all,
| > >> |
| > >> | I upgrade my MS Office from 2003 to 2007. Opened an Excel file and
| > >> saved
| > >> it
| > >> | as a new workbook. Now I have this hidden file with the name of my
| > >> file
| > >> | preceeded with ~$ and xlsx extension that refuses to go away. If I
| > >> delete
| > >> | it, it appears to go away then as soon as I refresh, it's back. My
| > >> files
| > >> are
| > >> | in my data folder on a network drive. The file is NOT open. My
| > >> workstation
| > >> | has been re-booted but the server with the user data files has not.
| > >> |
| > >> | Anyone know how I can get rid of that file WITHOUT re-booting my
| > >> server???
| > >> |
| > >> | Thanks,
| > >> | John
| > >> |
| > >
| > > --
| > >
| > > Dave Peterson
|
| --
|
| Dave Peterson
 
J

Jim Rech

wouldn't it be more useful to get the data than speculate ?

But that's exactly what I was doing, Bruce! By parading my ignorance and
ponderings I was opening the door for someone to step in with the answers.

Wait, lets see what Bruce has to say...

Gee, thanks Bruce<g>

--
Jim
in message | In article <[email protected]>, "Jim Rech"
| >>>I'll stay away from these pesky xl2007 questions.
| >
| >Now that's not the 'take away' here, Dave<g>.
| >
| >I'd like to understand the new temp files better though.
|
| Sounds like a good idea ... but surely MS has published this information
| somewhere haven't they ? Assuming they have, wouldn't it be more useful to
| get the data than speculate ? ... as fun as that is of course. :)
|
|
 
J

Jim Rech

I tried the Unlocker utility mentioned. Does the trick!

http://ccollomb.free.fr/unlocker/

--
Jim
| Do you think the file is locked and is failing to be deleted or do you
think the
| file is being recreated by something?
|
| Does the date accessed/modified/created change?
|
| There are some free utilities that will delete files even if they're
locked.
|
| I've never used these (on a local drive or on a network drive), but you
may want
| to look at these:
|
|
http://lifehacker.com/software/feat...p-has-locked-a-file-with-wholockme-267243.php
|
|
http://lifehacker.com/software/how-to/delete-a-locked-file-in-windows-266433.php
|
| If either help, please post back.
|
| Even though I don't know what I'm saying with xl2007, I'm still curious.
|
|
|
| John Holt wrote:
| >
| > Thanks for the reply Jim,
| > No, it didn't connect them. Saved the file just fine though.:)
| > I'm sure it will go away when I re-boot the server. Sure would be nice
not
| > to have to do that though.
| >
| > | > > Actually this does seem to be the new way that Excel 2007 tracks open
| > > files.
| > > What happens if you save an new empty workbook with the same name as
the
| > > hidden file (minus the ~$ of course)? And then close it. I wonder if
| > > Excel
| > > would connect them?
| > >
| > > --
| > > Jim
| > > | > > | Hello all,
| > > |
| > > | I upgrade my MS Office from 2003 to 2007. Opened an Excel file and
| > > saved
| > > it
| > > | as a new workbook. Now I have this hidden file with the name of my
file
| > > | preceeded with ~$ and xlsx extension that refuses to go away. If I
| > > delete
| > > | it, it appears to go away then as soon as I refresh, it's back. My
files
| > > are
| > > | in my data folder on a network drive. The file is NOT open. My
| > > workstation
| > > | has been re-booted but the server with the user data files has not.
| > > |
| > > | Anyone know how I can get rid of that file WITHOUT re-booting my
| > > server???
| > > |
| > > | Thanks,
| > > | John
| > > |
| > >
| > >
|
| --
|
| Dave Peterson
 
D

Dave Peterson

Lifehacker.com often mentions some very nice utilities.

You may want to bookmark the site--you know, when you're supposed to be working!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top