How do you make Excel 2010 open a new window every time?

How do you make Excel 2010 open a new window every time?

If this is the main reason you wish to open a new instance for each spreadsheet, it can be resolved by;

1. Open Excel.
2. Open the File Menu.
3. Click ‘Options’
4. Click ‘Advanced’
5. Scroll down to ‘Display’ Section.
6. Check the “Show all windows in the Taskbar” box.

How do I open multiple Excel 2010 files in separate windows?

All replies

1. Open Microsoft Excel 2010 and the first worksheet.
2. Right-mouse-click on the Microsoft Excel 2010 icon , choose Microsoft Excel 2010 (or Open) to open.
3. Open the second worksheet in the second instance of Microsoft Excel 2010.
4. Move the second instance of Microsoft Excel 2010 to the second monitor.

Can’t open 2 Excel files at the same time?

By default, Excel will use an already running instance to open other files. Simply open up Excel, then open your file. Then open up a second copy of Excel and open the second file. Now you can move the two Excel instances independently to your other monitor.

Why do all my Excel files open in one window?

Unlike previous versions of Excel, Excel 2013 separates each workbook into its own window, enabling you to simultaneously view all spreadsheets. If these windows are grouped in the taskbar, then Windows 8’s taskbar configuration is the culprit.

How do I stop Excel 2010 from opening a blank workbook when I open an existing File?

Microsoft Excel opens saved Excel file as blank workbook

1. Open Microsoft Excel.
2. In the Ribbon, click the File tab and click Options in the left navigation pane.
3. Click Advanced, then locate the General section.
4. Uncheck the box next to Ignore other applications that use Dynamic Data Exchange (DDE).
5. Click OK.

How do I stop Excel from opening in the same window in Windows 10?

10 Answers

1. Use the File Association Settings.
2. You have to tell Excel not to use DDE to open the worksheet.
3. Open Windows Explorer, Tools, Options, File Types.
4. Scroll down to XLS.
5. Select Advance Button.
6. Click on OPEN in the Actions window, Then Edit.
7. On the 2nd line for application used add “%1”.

Why is Excel opening a blank window?

This problem may occur if the Ignore other applications that use Dynamic Data Exchange (DDE) check box in Excel options is selected. This message instructs Excel to open the workbook that you double-clicked. If you select the “Ignore” option, Excel ignores DDE messages that are sent to it by other programs.

Why does Excel open a blank sheet when opening a File?

Microsoft Excel opens saved Excel file as blank workbook. Sometimes, when a user opens a saved workbook, it is blank. This issue is often caused when Excel’s settings are changed (usually inadvertently) to ignore external programs.

Why is Excel opening in the same window?

Microsoft Excel displays new worksheet tabs in the same window – resulting in many tabs in one open window if more than one file is open. Solution: To fix this, you need to tell Excel that you want each new window to open separately from your old file.

Why is Excel 2010 opening a blank File?

This problem may occur if the Ignore other applications that use Dynamic Data Exchange (DDE) check box in Excel options is selected. When you double-click an Excel workbook in Windows Explorer, a dynamic data exchange (DDE) message is sent to Excel.

How do you open a window in Excel?

Open your first instance of Excel, and then right-click the Excel tile on the Start screen. 2. Hold down the “Alt” key and click “Open New Window” on the Start screen taskbar. 3. Continue holding down the “Alt” key until you see a prompt asking you if you want to start a new instance of Excel.

How do you open a document in Excel?

Open an OpenDocument Spreadsheet in Excel Click File > Open > Computer > Browse. To only see files saved in the OpenDocument format, in the file type list (next to the File name box), click OpenDocument Spreadsheet (*.ods). Find the file you want to open, and then click Open.

How do you open two worksheets in Excel?

One way to view two worksheets of an Excel workbook at the same time is to display them side by side. Here are the steps. 1) Open the Excel workbook that contains the two worksheets you want to view side by side. 2) Click the View tab on the Excel ribbon, and then click New Window. Then Excel will open a second window of the same workbook.