If you close and save the file when you are viewing multiple windows, the window settings are retained. Therefore, when you reopen the workbook, you see the same multiple windows. Symptoms When you open a workbook, Microsoft Excel may display multiple windows that contain a copy of that same workbook. Cause This behavior occurs if the workbook was saved when multiple windows were open for that workbook. Resolution To change this behavior, close the extra windows, and then save the workbook.
To do this, follow these steps: Click the Close button the X in the upper-right corner of the window that you do not want. More Information Excel allows you to open multiple windows to view a single workbook. Switch to the new window, and then click a sheet that you want to view. Repeat steps 1 and 2 for each sheet that you want to view in a window. Need more help? Expand your skills. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums.
Excel IT Pro Discussions. This forum is for general questions and feedback related to Microsoft Excel all versions as they pertain to the IT Pro community. Sign in to vote. Please merge the similar threads. I didn't see how to add to a thread. This is an old issue. There is NO feature or change added in Excel more important than retaining the ability to work on 2 open Excel spreadsheets at the same time on 2 monitors.
I tried the workarounds and set the folder options and I don't get what I had before. I honestly don't care about the "why. Please fix this NOW. Dave S. Wednesday, August 10, AM. By lucky mistake I saw your post and I also have two monitors on my work computer! To open two different worksheets, one worksheet for each monitor follow the following tasks Open Microsoft Excel and the first worksheet 2.
Or like click one excel then shift click another file this seems to be a bug as it forces the settings for some cases. Yeah, the interesting thing is that throughout most of the Google searching I've done on this, I've seen "that's not supposed to work in Excel " as the general answer.
But this user was definitely able to run multiple instances of Excel and has been doing so for years. That was actually one reason she added the second monitor a couple of years ago. But yeah, for that reason, she's not accepting the "it's not supposed to work in at all" explanation. So whatever happened to her yesterday, apparently didn't happen to this one. I'm planning to look at that other workstation to compare settings and see if I can spot any differences.
But that is a thought, I guess especially since yesterday was Tuesday. This has been going on for years, since Office You can read all about it clear back to The simple solution? Upgrade to Office or better. Our business office was able to have multiple instances of Excel open without issue in Windows Then we needed a work around. The easiest thing for our people was to pin Excel to the task bar and have it open a 2nd instance by right clicking on it.
My answer to the "I've never had to do that before" is usually, "well, there was an update and it changed that feature, so now you have to do it this new way. To sum up, you should open new blank Excel workbooks in different windows first of all, and then separately browse and view the Excel files that you want to open in these new workbooks. Now follow the below steps and instructions to learn how to do it. There are several ways that you can adopt to open new instances of Excel in different windows.
Choose one as per your preference from the below 3 options. First of all, open an Excel workbook that you want to view in advance, hold the Shift key on the keyboard and then click the Excel icon on the taskbar.
Then a new blank workbook in another window will be created. Alternatively, you can right click the Excel icon and select Microsoft Excel or use the wheel on your mouse to click Excel icon to open a new instance. Repeat the steps to open more Excel workbooks in different windows. Press the Windows icon on the keyboard, enter " Excel " into the search bar and the click the icon of Microsoft Excel to open an Excel workbook.
0コメント