2 workbooks open when only one is selected

Mathman

Board Regular
Joined
Jan 28, 2017
Messages
144
Office Version
  1. 2016
Platform
  1. Windows


Not sure what changed but when I open up a workbook I now always get a second blank workbook that opens up as well.


Also when I click a cell it now acts like I have double clicked it which is a little frustrating.


Any ideas why this is happening and how I can fix it?


Thank you
MM
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

bugmonsta

Board Regular
Joined
Dec 17, 2013
Messages
214
Hi,
is the 2nd window called personal.xlsb? If so click on this window and to get rid of it is to go to the View tab and click Hide. This file is where your personal macros may be stored. I had it opening for a while and it annoyed me so I have hidden mine from view.

if its not called personal.xlsb then I found the instructions below on answers.microsoft.com (this is a link to the post/page) - In this example option C cured the issues as the user had recently installed MySQL and this set an option to open a blank Excel file each time via a COM add in!!

Please make a note of any options you change as if it doesn't cure the issue then I always think its best to put the settings back :)

Please try the followings to see the result:
a.Disable preview pane in File Explorer (open File Explorer, click View tab and make sure Preview Pane is not enabled).
b.Navigate to C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART check if there is any file and move it to other location.
c.Open Excel and go to File tab->Options->Add-ins, Set "Manage" to "COM Add-ins" and click Go, Write down which add-ins are selected, uncheck them all, choose OK.
 

Mathman

Board Regular
Joined
Jan 28, 2017
Messages
144
Office Version
  1. 2016
Platform
  1. Windows
looks like it was MySQL that was creating the issues. Strange how it would create such problems. Thank you for the help, it's greatly appreciated.

MM
 

Watch MrExcel Video

Forum statistics

Threads
1,108,732
Messages
5,524,516
Members
409,583
Latest member
gkarthick

This Week's Hot Topics

Top