Reinstate the ability to open multiple workbooks in a single instance in Excel
I do not understanding the logic behind your decision to remove the ability to open multiple workbooks in a single instance in Excel. The only benefit is the ability to immediately move work books to two separate screens basically giving the ability to do the simple task of copy and paste. FYI: available on all spreadsheets!!! What made Excel a valuable tool was it ability to reduce time by accumulating data from multiple workbooks instantly and limiting the use of resources (ram). It also reduced the amount of data on a single workbook and protected the master since a simpler spreadsheet could be sent out and filled in without worry of corruption. This was accomplished because Excel could be linked to hundreds of spreadsheets and utilized macros that could import data from multiple workbooks. These features are no longer available if the workbooks open in a separate instance. Microsoft was based on business and this feature is what made Excel a valuable tool. Why!!!!
I use my PMW as my Excel "toolbox" and library (after all it is just a normal workbook but with a special name). Like your's, mine holds generic tools that I use across any open workbook (no trouble so far), but in it I also store sample code (which I copy to other WBs as req'd), sample sheets, sample formula, as well as examples of Data Validation, Conditional Formatting, Dates, etc.
A Workbook_Open proc. I have in my (hidden) PMW opens several other workbooks upon startup - and which seems to work just fine, except that only one is added to the PMW instance and the other in its own. However, from what I can tell, there is only one copy of my PMW open across all instances rather than multiples as per your experience.
Thank you Mats. I will try to find a workaround and if I cannot I will post in those forums for help. I hope/wish other users also find solutions for their problems. Good luck for them.
When any one pays for a license, he is entitled to receive support from the company. If MS does not help its customers any more, I will seriously consider moving to Linux and open source software.
FSoriano: Post your problems on the different Excel forums like MrExcel or Stackoverflow. There are plenty of expert programmers available to help you out! Good luck!
Mats and Col,
Thank you for your answers. I am an engineer, but not an expert programmer. When I need something, I find the way to do it. In this case, I recorded a macro, where I switched from a main excel worksheet to the others where I had the data, copy it, and bring it to my main worksheet.
The macro worked perfectly for years,... until I upgraded to Excel 2016.
I will try to follow your indications, but it is quite cumbersome for me. I need to find out what are most of the things you say, and how to do it.
It is also very frustrating to see how Microsoft support has deteriorated over time. 18 years ago I reported my first problem, and a guy from MS gave me a phone call and solve it. I had a second problem 6 years ago, and the problem is still there even with Excel 16. This is the third problem and it seems MS is not even going to answer.
Hey FSoriano and Col Delane: there shouldn't be any problem copying and pasting information between different workbooks if they are referenced properly and you don't need the PMW to do it.
I use a Workbook_Open procedure in ThisWorkbook on the main WB to create my environment and opening the data WB's. In that way they always have the same premise when I copy information from the data WB to the main one. You may even set a reference to the main WB in VBE/References, then you get access to the objects in the main WB from the data WB. (Now the main WB cannot be closed before the data WB). I use the PMW only for generic tools, i.e. small procedures that should be available across any workbook I open. The PMW definitely has a problem when it's hidden as I commented earlier.
Hey FSoriano: I didn't mention it in my earlier comments to this post, but generic macros (tools, etc.) in my personal macro workbook ("Personal.xlsm") work fine on workbooks open any instance, so I'm wondering why you and others have the problem where code in one workbook fails (at least sometimes) when trying to access/manipulate workbooks in different instances. Perhaps this is due to the "special" nature of Personal.xlsm? As a fix, have you investigated whether or not you can insert some code at the beginning of your existing code to make the target workbook 'visible' to the code (e.g. by "Switch Windows" which as I mentioned in my earlier post seemed to change which two workbooks occupied an instance)? Just a thought.
Different instances are a big problem for our company. We considering reverting back to Excel 2010 because of this.
you wonder why Microsoft encourage us to comment on UserVoice when they never pay any attention! But every week I receive feeds about all new fancy features they created in Sharepoint, Office365 Online and Office365 admin center. What about putting some efforts for fixing up a dysfunctional Excel. No never, because it would be to admit they took some poor decisions! Sigh!
Well, I see many comments here, pointing to the same problem. But, I do not see any answer from Microsoft. Hey, Microsoft, are you there, are you listening? Do you plan to do something or helping us somehow???
Different instances are a big problem for me. I have a macro to copy data from data workbooks to the my main workbookt. I built it in Excel 2013, and now, using Excel 2016, my macro some times works, some times it doesn't.
I found that the problem is that when I open the data workbooks, randomly, some times they open in different instances and sometimes they open under the same instance. If they open in different instances, my macro doesn't work. Why have you change this? I NEED ALL TO OPEN UNDER THE SAME INSTANCE!
After further experimentation I've "discovered" the following odd behaviour:
1. Irrespective of how you open an Excel workbook (e.g. via XL File Open ribbon command or double-clicking the file in Windows Explorer), each will be opened in a separate instance.
2. In any single instance, Ctrl+Tab will allow you to switch/cycle between the workbook of that instance plus only one other workbook. However, that "one other" workbook can be changed to create a different pairing either by (i) using the Ribbon command View / Switch Windows (where ALL open workbooks are listed) or (ii) selecting the target workbook in the Taskbar across the bottom of the Excel window (where thumbnails of ALL open workbooks are shown)
3. Curiously, Ctrl+Shift+Tab will allow you to switch/cycle between ALL open workbooks (not just cycle thru open workbooks in reverse order like Excel 2010 & prior allowed!).
4. Formula links can be created between ANY open workbook but to access all workbooks you must use the Ribbon command View / Switch Windows (where ALL open workbooks are listed) or by selecting the target workbook in the Taskbar across the bottom of the Excel window (where thumbnails of ALL open workbooks are shown) - but even more curiously you CANNOT use Ctrl+Shift+Tab to switch to the desired workbook as described in 3 above!
This is a clear demonstration of Microsoft's lack of thought, consultation, & testing when modifying the application!
Microsoft's Excel product developers appear to not understand the axiom "If it ain't broke don't fix it!"
Overcoming the 2GB RAM limit per instance was a worthy objective, but in doing so they have treated their user customers with contempt and caused significant collateral damage to the ease of use / functionality. Not happy Bill!
I agree. They also changed that Control Tab feature. Before you could Control Tab through all workbooks, and then Control Shift Tab backwards. Now the Control Shift Tab doesn't work at all, and Control Tab is between 2 workbooks. Now we need to use Alt Tab back and forth. Alt tab should only be for applications.
We are also considering reverting to Excel 2010, it was an excellent version!
Another problem with the SDI is that if you work with hidden workbooks, (the most common is personal.xlsb but we have others as well) and run a procedure that opens another workbook, you'll get new instances of the hidden WB's as well. When the procedure eventually is closing the second or third workbook, Excel doesn't know how to handle the hidden ones and opens/keeps them as blank visible workbooks. You have to manipulate them via VBA or manually hide them again to get rid of multiple blank workbooks as they can't be closed, they are connected to the parent session! This is a fundamentally poor programming solution and I'm very disturbed that Microsoft never is coming up with a solution to a well-known problem.
I am seriously considering installing 2003 again. It pretty much worked like we all need it to! Frankly 2016 is not fit for purpose and we should all ask for our money back. The number of times the whole thing freezes for 30 seconds with nothing on the screen is also driving me crazy. I've moved the same file from a 10yr old laptop to a brand new core i7 with flash drive and masses of ram and this 2016 Excel is now ****! Smaller file size yes but so sluggish and all files in separate instances, even duplicate windows which even makes saving more complicated arrgghh!!!
Ian Sims commented
One of the many problems with SDI is that unless you Unload a userform, that form will always change the active window to the workbook that loaded it. So if you have a general utility with a form involved you have to Unload the form every time it is used. Which means the whole userform_initialize step has to be gone through again each time, which for forms which use a fair amount of data kills the immediacy of the thing, plus adds a whole bunch of programming needs to maintain the last used box state.
This has been a really major change which clearly has not been thought through. I am certainly looking at alternatives to Excel since I just can't depend on Microsoft not to fundamentally change something else which will cause me another unnecessary investment of time to re-write thousands of lines of code just to cope with another MS brainfart.
Ability in Excel 2016 to open multiple spreadsheets in the same Excel 2016 window? If so, this feature is not available in Excel 2016 and has been discontinued since Excel 2013.
Is there a chance that the development team will return this feature that allows you to work with multiple files under one Axal?
I am an economist and have worked for years with a lot of files and this work my mostly move from file to file.
The security of this option obligates me to relate to each issue separately as well as to the definitions, which is not really
Hello All, I'm still looking and waiting for a reply or comment from anyone from Microsoft. No news is no news or maybe they just don't care. I am convinced that nobody at Microsoft reads any of this. Time to find something else to replace what was a good program. Shame really.
I'm having the same problems as everyone else. I notice someone has offered a solution using the 'Open' command from the file menu. This does work, but it's cumbersome, if I have 3+ workbooks in my recents list, I can't click on them as they'll open in a new instance. I have to select the Open command and then search for them from their original location. Otherwise it's impossible to do lookups between workbooks. This is going to have an huge negative impact on my ability to do my job.
Christopher Starr commented
I don't understand why they took this away, when in 2013 you had an option to open another instance if you wanted to anyway.
Why not just add an option in Excel, if you want all to open in a separate instance you tick a box and there you go.
So many people I know and by the looks of things people global find the value in opening in the once instance without multiple **** Ribbons!!!!!