Home/ Questions/Q 10809
Next
Answered
computing
  • 2
Asked: 2021-12-06T12:05:30+00:00 In:

Solved Why Does An Excel File Have ~$ In Front Of It.

  • 2

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 ?

Share

    1 Answer

    1. 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

      • 0