Avatar of Justin Smith
Justin Smith
Flag for United Kingdom of Great Britain and Northern Ireland asked on

help! got 2 versions of the same spreadsheet in my Excel and I cannot find how to fix it?

hi, I have got a spreadsheet open and when I go to Switch windows, it's shows the same spreadsheet but one is called -1 and the other -2. how do I fix this?
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon
Martin Liss

You aren't looking at a split window. Close one of them.
Justin Smith

hi, how do you close them? I did File - close. reopened it and there are still 2 versions'
Martin Liss

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

I’m glad I was able to help.

If you expand the “Full Biography" section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015 and 2017
              Experts Exchange Distinguished Expert in Excel 2018 and 2021
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2020
              Experts Exchange Top Expert VBA 2018 to 2020
Your help has saved me hundreds of hours of internet surfing.
Rob Henson

Looks like the same issue you had in your previous question on 25 January.

Does another user have access to these files? If so, you can check with them for what they are doing.

The process for making this happen is very simple so they may not realise what they are doing.

On the View tab, they are selecting New Window, as per below:

This duplicates the active workbook in another window. This can be useful in some scenarios, for example if you have a workbook with tabs for Current reporting period and prior reporting, you could have the current tab in one window and  the prior tab in another window for visual comparison or for copying data between them.

If saved with two windows open the file will reopen with two windows.

I have found that the second window doesn't always maintain the same view settings, freeze panes etc, so have found it is always best to close the second window before saving and closing.