Home

Problems we all know excel has

Many people are tired of the way excel workbooks are affected by every other workbook you have opened. When you calculate one, they all calculate. Excel acts as though they are inter-dependent when they really aren't. Well with a simple registry injection, you can add a right click menu to the shell that lets you open excel in a new instance instead of just opening another excel workbook in the same window as any existing one.

Another great side effect is that you can finally view documents side by side instead of awkwardly having to un-maximize windows within the application and arrange them. Having multiple excel instances in infinitely useful. If one workbook crashes, the rest will remain intact! This is the perfect solution for workplaces that thrive off a variety of excel applications and frequently experience mass crashes and restores.

The following solution is adapted from a general solution involving editing the advanced properties under explorer folder options for file types. I went directly to the source and created registry editing files that would add the new context menu, and even make it the default behaviour if desired.

The end result:

Instructions

If this is something you want, then copy the attached code into a .reg file, or download the registry editing files. Note that there are 4 variations - one adds the new menu option and makes it default, one just adds the menu option, but leaves "Open" as the default. The last file is used to remove the changes from the registry and put everything back how it was before.

Note that you can use the files in any order. If you add the menu option, then decide later you want it to be the default behaviour, you can run the first file after the second one. Similarly, if you want to undo making it the default behaviour, you can run the "Remove changes" file and then run the second file to add the menu item back without the default.

What to expect

A quick tip - if you are having problems copy pasting, remember that excel advanced formatting only copy pastes between separate workbooks if they are in the same instance (probably why Microsoft made same-instance opening the default behaviour.) If you need to copy paste between two workbooks, then you should be opening them in the same instance, so select the normal 'open' for these, otherwise, you should be happy with separate instances.

Another note is that separate instances of excel consume more memory. If you have enough workbooks open that this affects you, though, then you'd probably be experiencing issues in a single application instance anyways.

Summary

Convert the .txt files to .reg files and double click them to add their info to the registry.

The code contains the same three entries for each format associated with Excel. If you understand what I'm doing here, you should have no problem adding or removing formats based on whether you have another version of excel, or different formats that you want behaving this way.

By default, I've included code for Excel 2007, and 2010, including 2010 x86 on a 64 bit Windows machine. There are files for adding the registry entries, making them default, removing them, etc. Make sure you read each option carefully and choose only the one most relevant to you.

If you do not with to modify the registry, or you do not have permission to do so, you can use "New instance of Excel.bat" as an "Open With..." target. Opening excel files with this .bat file will open the file in a new instance of excel. Warning, if you choose the .bat file the default "Open With" program, excel icons will be replaced with a much less appealing one.