Forum Discussion
How to open Excel Spreadsheets in SEPARATE windows
Like Theo_Bear and and Nabil, your question is not totally clear to me either. If by "multiple spreadsheets" you actually mean "multiple workbooks", it sounds as if you want to know how to open each Excel workbook in its own dedicated instance, so they show up as such on your task bar as you mentioned. If that is what you want, this picture shows 2 methods for achieving that objective.
I suddenly had Office 2010 stop opening different Excel Files (ok worksheets) in their own instance, when they were doing it previously every time. Not sure what happened to make them stop doing it, but suddenly I could only view one at a time. If I went to File Explorer and double-clicked they would open and take the place of the one I was looking at. I can see there are 2 open only by looking at the task bar, where they are tiled. Your instruction to go to Start and then Alt-Click Excel did open a new instance and I can then view the to workbooks side by side as their own instance.
The question is how to restore the behavior to open a new instance any time I click a workbook, like it was.
This laptop is Win 7 Pro ( Don't lecture me) with MS Office Professional Plus 2010
For the record, my wife's laptop, with Win 10 still opens a new instance of Excel every time just like we want. She's using either Office 2010 or 2016.
My Work laptop uses 365 in Windows 11 (yuck) after a recent upgrade from 10 got pushed out. However, it behaves like I want, and opens a new instance every time also. No, I don't open them in Edge. It's set to open in Desktop App. I did nothing to set the behavior, it has just always been that way. It's only my Win 7 Desktop that started this weird behavior.
Any help is appreciated, and I thank you in advance,
Michael
- ChrisRodeoApr 04, 2024Copper Contributor
Any answers or luck with this question, I too use to be able to launch multiple applications of Excel,,,, Miztrniceguy
- MiztrniceguyApr 05, 2024Copper Contributoryes, so go to this site:
https://blog.whitesites.com/Force-Windows-7-to-open-excel-documents-in-separate-windows__634014706378053750_blog.htm
scroll down to this entry
Kenton | Oct 11, 2010 10:35 AM
This Regedit is what worked for me, with Windows 7 and Excel 2010. there is an entry above it that is supposed to work with different versions.- ChrisRodeoApr 05, 2024Copper Contributor
Thanks Miztrniceguy