Error of not being able to open 2 Excel files at the same time and instructions on how to fix it

Why can't you open 2 Excel files at the same time? How do you overcome? All answers have been shared by TipsMake in the article.

The error of not being able to open 2 Excel files at the same time makes you extremely tired. It greatly affects the quality of your work. How to fix it? Why is that. Please refer to the method below to solve your problem!

Excel is an indispensable support tool in the study and work of almost everyone. Sometimes the nature of your work requires you to work on 2 Excel pages at the same time to conveniently compare data. But when you open a new file, the old page is gone and you don't know how to do it. I hope the answer below will help you.

Error of not being able to open 2 Excel files at the same time and instructions on how to fix it Picture 1

What is the cause of the error of not being able to open 2 Excel files at the same time?

Similar to other Excel problems, there are many causes of this situation as follows:

When your Excel file has an error > cannot open the file: Please check using another device and open your file to see if there is the same error as the previous device. If so, use the feature. Recovery in Excel and edit it.
When your memory is too full: Your computer has low RAM capacity, it also causes the situation of not being able to open files in Excel, check your memory to make sure RAM is not missing causing errors, if it is missing you must Update RAM to fix this error.
When installing Excel is faulty or inappropriate, it will also affect opening 2 files at the same time > Check your Excel settings and reset the computer. If it still doesn't fix it, reinstall Excel.

Error of not being able to open 2 Excel files at the same time and instructions on how to fix it Picture 3

Looking for a way to fix the error of not being able to open 2 Excel files at the same time

1.Instructions on how to fix not being able to open 2 Excel 2010 files at the same time

Step 1 : Open the Excel file, click File , select Options .
Step 2 : Continue to select Advanced and search for Display and select Show all windows in the taskbar , you can execute 2 files at the same time.

Error of not being able to open 2 Excel files at the same time and instructions on how to fix it Picture 5

2 Simple instructions for splitting the screen into two

Move the mouse to the position to minimize the page of the Excel file, click to minimize and display the file. This is an extremely simple and quick method that is easy to apply, but it can only be done on Windows 11 version.

If you are using an older version, please refer to some other methods below.

Instructions for splitting the screen in half using the command on the Taskbar

Step 1 : Open the Excel file you need to open first > select the icon in the upper right corner to minimize the Excel file screen.
Step 2 : Hold down the Shift key + Left click on the Excel application on the Taskbar .
Step 3 : After opening the Excel file, open the File tab .
Step 4 : Select Open > Select the Excel file you want to open.

Error of not being able to open 2 Excel files at the same time and instructions on how to fix it Picture 7

Hopefully, after reading this article, all your difficulties about the error of not being able to open 2 Excel files at the same time will be resolved. Wishing you the best in completing your work.

Isabella Humphrey

Update 09 December 2023

You should read it

May be interested

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving
this can be said to be a problem that many users encounter, that is to close the text file, office has just worked but forgot to save - save again. or in case of a sudden power outage, the computer has a blue screen error, hangs up ... all can happen at any time. so, if you want to find out what excel, word or powerpoint files have not saved, what should you do?
Instructions for opening Zip files on Android and iOS
although the most popular compressed file format in the world today, zip files do not work well on smart phones. when trying to open a zip file on ios and android operating systems, you will often receive an error message. however, with an appropriate third-party application, problems with these zip files can be easily solved.
What is ### error in Excel? how to fix ### error in Excel
### in excel is an error that excel frequently encounters and appears in many different cases when we enter data in excel, functions in excel, enter formulas in excel or when displaying results.
Fix Unable to unlink error in Excel
instructions on how to fix the error cannot be unlinked in excel, this is an error that users often encounter while using excel spreadsheets.
Instructions to fix Excel column/row freezing not working
in some cases, you don't see the option to freeze excel columns or rows, which affects document processing and overall view of the data table.
Common causes of Excel workbook errors
lost your work on excel due to file corruption? understanding the errors that cause damaged excel files will help you avoid that from happening.
How to Open Password-Protected Excel Files
this article explains how to remove the password of a protected excel worksheet and how to crack the password of an encrypted excel file. in most cases, removing the password of a worksheet that is locked from editing in an excel file is quick and simple! however, if you need a password to open the file, the operation will be more complicated. there is no official way to decrypt excel files without using a password cracking program - often a resource-intensive process depending on the complexity of the password. you should still try it though!
Office files are corrupted after upgrading to Windows 10, how to fix?
after upgrading from windows 7/8 to windows 10, many users encounter the following error: their office 2013 text files cannot be opened. so how to fix this error?
Instructions on how to open Word files, Excel suspects infection
with a suspected word or excel file infected with a virus, we can use the google docs tool to check the content inside without having to download the file. so how to use google docs to open excel and word files with virus.
10 ways to recover corrupted Excel files
here are 10 simple ways to recover files, excel spreadsheets are corrupted before considering ... crying or reworking from the beginning.