Open file as copy

How to open a new copy of a Excel file?
If a copy of a file is opened, where would be the copy?
I have opened a file as copy. Can I use access the file after it is closed?

To open a file as copy, just follow the steps

• Select your file through the file open box (CTRL+O)
• Now at the bottom you may notice an ARROW BOX next to the OPEN button (in fact, it is a drop down box)
• Click the arrow and select OPEN AS COPY.
• Now you could be having a copy of the original version of the file.

Where is my Copy file?
How to access my Copy file?
If you open a Excel file using the OPEN AS COPY option, then a new file is created and saved in the same directory of the original file. So if you have a file, say test.xls in D drive. Then if you open the file as copy, then Excel creates a file in the D drive with the name Copy(1) of test.xls.
You can access this file through the path D:/Copy(1) of test.xls. You can always rename and copy your file somewhere else but by default Excel saves the copy of the file in the same drive. Also, Excel duplicates the original file and whatever is in the original file, it is copied including formats, formulas and other functionalities.

Multiple copies of a single file
If you open multiple copies of a single file, then Excel number it in ascending order. So if you open a second copy then Excel gives it the name D:/Copy(2) of test.xls and the third copy is named D:/Copy(3) of test.xls. So you can always access the. If you open the copy of a copied file then excel names it as copy of copy, copy of copy of copy and so on.
In the above example, if you open the file Copy(1) of test.xls as a copy then Excel names it as Copy(1) of Copy(1) of test.xls and if you open this file again as Copy then Excel would name it as Copy(1) of Copy(1) of Copy(1) of test.xls. It may sound a bit confusing but its quite clear.

Open a file as copy only it is absolutely required or you are working on an important file or you are working on other's job and need to preserve the original data. Opening a file as copy takes up disk space (its nothing when compared to 40GB disks and more) and adds your files list and make us a mess of things if you open too many copies.