Opening Excel File Leads to a Grey Window when Data Analysis Toolpak is Enabled

%3CLINGO-SUB%20id%3D%22lingo-sub-1768378%22%20slang%3D%22en-US%22%3EOpening%20Excel%20File%20Leads%20to%20a%20Grey%20Window%20when%20Data%20Analysis%20Toolpak%20is%20Enabled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1768378%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20seen%20in%20the%20attached%20image%2C%20When%20I%20open%20an%20excel%20file%20via%20double%20clicking%20the%20document%2C%20a%20grey%20small%20excel%20window%20is%20opened%20along%20with%20the%20actual%20excel%20sheet.%20I've%20messed%20around%20with%20some%20settings%20and%20did%20some%20research%20and%20limited%20down%20to%20the%20fact%20that%20this%20only%20occurs%20when%20the%20Data%20Analysis%20Toolpak%20(with%20VBA%20as%20well)%20add-in%20is%20enabled.%20When%20I%20close%20the%20grey%20window%2C%20the%20excel%20sheet%20closes%20along%20with%20it.%20It%20seems%20enabling%20the%20add-in%20forces%20the%20program%20to%20run%20some%20background%20tasks%20upon%20starting%2C%20and%20either%20never%20finishes%20or%20stalls%20or%20whatever.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22justin13601_0-1602390772637.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F225772i2E9C47306D178EBF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22justin13601_0-1602390772637.png%22%20alt%3D%22justin13601_0-1602390772637.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20why%20this%20is%20happening%3F%20Any%20suggestions%20to%20a%20fix%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1768378%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi all,

 

As seen in the attached image, When I open an excel file via double clicking the document, a grey small excel window is opened along with the actual excel sheet. I've messed around with some settings and did some research and limited down to the fact that this only occurs when the Data Analysis Toolpak (with VBA as well) add-in is enabled. When I close the grey window, the excel sheet closes along with it. It seems enabling the add-in forces the program to run some background tasks upon starting, and either never finishes or stalls or whatever.

 

justin13601_0-1602390772637.png

 

Any ideas why this is happening? Any suggestions to a fix would be greatly appreciated.

 

Thanks in advance!

0 Replies