Open New Instance of Excel 2010 with every file

excel excel-2010
johnf picture johnf · Jan 14, 2011 · Viewed 95k times · Source

I am using Excel 2010 and want to manage a large Excel files.

So I would like to open a new Excel Instance when opening every file from my Windows Explorer. At the point all files are opened in the same Excel Instance.

Any assistance is kindly appreciated.

John.

[ I fould this: http://www.online-tech-tips.com/ms-office-tips/how-to-open-a-new-instance-of-excel-2007-workbooks/ ]

Answer

Simon Cowen picture Simon Cowen · Feb 1, 2011

Go to a folder in Windows Explorer, then Tools -> Folder Options, then the File Types tab. For each of XLSM, XLSB, XLSX, etcetera, select it, then click Advanced, select Open in the Actions list, then click Edit.

Adjust the settings to:

Application used to perform action: - "C:...\EXCEL.EXE" "%1"

Use DDE - Checked

DDE Message *LEAVE BLANK*

Application - Excel

Topic - System

Related questions

IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
Remove leading or trailing spaces in an entire column of data

How do I remove leading or trailing spaces of all cells in an entire column? The worksheet's conventional Find and Replace (aka Ctrl+H) dialog is not solving the problem.

Read More
Insert picture into Excel cell

I'm tying to generate a report with pictures, but I cannot get the pictures into a single cell. I can get the pictures to "float" around my worksheet, but I need to put them into a cell. How can I …

Read More