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
Last Comment
Rob Henson
You aren't looking at a split window. Close one of them.
ASKER
hi, how do you close them? I did File - close. reopened it and there are still 2 versions'
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
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.
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
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
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.
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.