Your buddy's choice of naming is unfortunate. Backup copies are a fantastic idea but their naming choice was unfortunate. My bet is Microsoft will tell you to name it a little different.
Recently, when I open a file in Excel, I noticed that it would automatically create a copy of that file in the same folder with the name 'Copy of filename'.xls or xlxs. I tried to figure out what was causing it but after a while, it stopped so I relaxed.
Recently, a colleague edited some of my files and in order to keep the originals, he renamed his versions 'Copy of filename'.xls. Now if I open the original file and then try to open the copy, I get the message "A document with the name Copy of filename.xls is already open. You cannot open two documents with the same name...". If I open the copy first, I don't get this error.
I can't find this invisible open file. It's not listed in the task manager, it's not a hidden file in my folder, it's not in the XLSTART folder ( I got that from google), I can't find it anywhere and I don't understand how it opens.
The only way I could get around it temporarily was to close excel and then go to task manager processes and close EXCEL.EXE *32. But I have to do this for every new file.
Please help. Thanks.