Home

Excel Closes for User When Opened - Active Data Connection

%3CLINGO-SUB%20id%3D%22lingo-sub-740003%22%20slang%3D%22en-US%22%3EExcel%20Closes%20for%20User%20When%20Opened%20-%20Active%20Data%20Connection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740003%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Excel%20Workbook%20with%20an%20ODBC%20connection%20to%20DB2%20using%20Power%20Query.%20When%20I%20send%20the%20file%20to%20one%20of%20my%20users%20via%20Outlook%2C%20the%20file%20opens%20for%20him%20but%20then%20Excel%20closes%20right%20after%20he%20opens%20it.%20I%20do%20not%20have%20the%20option%20checked%20to%20automatically%20refresh%20the%20data%20upon%20opening.%20What%20is%20wrong%3F%20Is%20it%20some%20sort%20of%20Trust%20Center%20settings%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-740003%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-746985%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Closes%20for%20User%20When%20Opened%20-%20Active%20Data%20Connection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-746985%22%20slang%3D%22en-US%22%3EDoes%20this%20also%20happen%20if%20he%20saves%20the%20attachment%20to%20disk%20and%20then%20opens%20it%20from%20the%20disk%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-747730%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Closes%20for%20User%20When%20Opened%20-%20Active%20Data%20Connection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-747730%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20reinstalled%20Excel%20and%20it%20worked%20for%20him%20now.%20thanks%20for%20the%20reply.%3C%2FP%3E%3C%2FLINGO-BODY%3E
RPietrzak
New Contributor

I have an Excel Workbook with an ODBC connection to DB2 using Power Query. When I send the file to one of my users via Outlook, the file opens for him but then Excel closes right after he opens it. I do not have the option checked to automatically refresh the data upon opening. What is wrong? Is it some sort of Trust Center settings?

2 Replies
Does this also happen if he saves the attachment to disk and then opens it from the disk?

We reinstalled Excel and it worked for him now. thanks for the reply.