Implement Quasi MDI Windows using Windows 10 Sets Feature
In Windows 10 there seems to be a feature, still under development called Windows Sets. https://www.howtogeek.com/352109/how-to-use-sets-in-windows-10-to-organize-apps-into-tabs/
While MS pulled this feature from the latest public builds of Windows 10, it looks like it’s not dead, but sleeping, due to make a comeback once issues have been ironed out. https://www.theinquirer.net/inquirer/news/3081852/windows-10-sets-coming-back-rumour
If this is the case then it would be the perfect way to bring make MDI like functionality to Excel for those users who miss it. Certainly from a Excel custom Application perspective MDI windows worked very well.
It would be great to have a setting in a future version of Excel such that by default Excel would tab all the Windows together that made up each process. This would nearly give the effect of an MDI application, as the key issue for some Excel Applications is determining which Excel Windows belong to which Excel process.
Andrew Lockhart commented
Thinking about it a little more I wonder if this could actually be implemented without the Excel team actually doing anything. I am presuming the Windows10 Sets feature has an API and it must have some kind of name/id for each set - I'm just guessing here.
We want to group each all the windows together that are part of the same process. So in theory a third party Excel Addin could do this. But there would have to be careful thought about this as what if you did want to see two workbooks from the same process at the same time? The logic would have to cope with you wanting to unclip one window then clip it back and also not allow you to clip windows of different processes together.
With the current situation I put the Excel Process ID in the Excel Caption and also try and educate Excel users about Ctrl+Tab to cycle through workbooks in the same process. There is also a Windows API that you can call so that all the workbooks for each process are grouped together which makes things slightly easier.
Speaking not only on my own behalf but also other colleagues from the company I work at, the lack of MDI is quite pauinful. Any solution bringing back the funcionality is wellcome with arms wide open.
Persobally I have doubts whether MS is indeed interrsted in making our lives easier or just try to switch us to their brand new shiny software solutions (which in my case won't work)
Matt F commented
Anything would be better than what we have today. I hope there are still people alive at MS actually listening to clients that buy their programs, but I have my doubts. M.