Question Locked

Excel 2002 Spreadsheet opens two copies with :1 or :2 added to filename

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When I open my spreadsheet two copies appear. One copy is named file:1 the other is file:2. Changes made to either copy are replicated to the other, closing one file closes the other. Renaming the file does not stop the behavior. This is a new behavior for a spreadsheet which has been in use for a long time. Creating a new spreadsheet appears to work normally. Also, ran repair in the problem spreadsheet and it did not resolve the issue.

6 replies

by sarahrogers

I am having the same problem. Did you solve the problem?

by ic-it

Select the window that you want to close, and press Ctrl + w

Save the remaining file and the problem should be gone.

by dcraker

This happened to me today, and I was wondering how to even find the answer. And I came across this in the Searches.
Thank you for this answer, that helped alot.
But how did it happen in the first place? I would like to know, so that I can arrange my program to prepare for that.

Thanks again, you saved me probably hours and hours of work and searching.

This discussion is closed to new replies.