Microsoft Excel Question:
Download Questions PDF

I have an Excel file that I use every day at work. Some time ago, mysteriously, the file began opening two copies of itself every time I double-click the icon. If I close one of the copies, both close. Any changes made to one copy show up in the other?

MS Excel Interview Question
MS Excel Interview Question

Answer:

This sounds like you just have two windows open that are displaying the same workbook.

Select the window that you want to close, and press Ctrl + w

OR, you can close the extra window by clicking the lower of the two X buttons in the upper right corner of the screen (don't click the top X button, as that will close Excel). Then save the workbook.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
When I click on an Excel file to open it, the file opens but an error message is displayed that says a file with that name is already open and that I can not open two files open with the same name?When I start XL, I get the error message Compile error in Hidden Module?