Solved Why does an excel file have ~$ in front of it.

January 28, 2020 at 16:20:50
Specs: Windows 10
I have that ~$ on a file but it & a file with the same name but with no signs in front are both empty ? Where is my data ?

See More: Why does an excel file have ~$ in front of it.

January 28, 2020 at 17:14:57
✔ Best Answer
The following is from an MS Knowledge base regarding Word files, which I believe applies to Excel files also.

As far I know, the temporary file is supposed to be deleted when you close the original file, although I've seen this sort of thing happen before. Hopefully, you have a backup copy of your file. If not and the original file is corrupted, you may be out of luck.

You might try moving the file without the ~$ to another directory and see if it opens there. Good luck.

"Owner File (Same Directory as Source File):

When a previously saved file is opened for editing, for printing, or for review, Word creates a temporary file that has a .doc file name extension. This file name extension begins with a tilde (~) that is followed by a dollar sign ($) that is followed by the remainder of the original file name. This temporary file holds the logon name of person who opens the file. This temporary file is called the "owner file."

When you try to open a file that is available on a network and that is already opened by someone else, this file supplies the user name for the following error message: This file is already opened by user name. Would you like to make a copy of this file for your use?"

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Report •

January 28, 2020 at 17:25:02
i only discovered the empty file after trf it from my old computer to a new computer. Something obviously happened last time I had it open in my old computer. I don't have a backup of it.
Thank you for your assistance.

Report •
Related Solutions

Ask Question