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
Highlighted
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
Highlighted
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.

Related Conversations
Matching date input to the formatted date display
Erikstg in Excel on
1 Replies
Can I use wildcards with the new FILTER function
StuLux23 in Excel on
13 Replies
Please guide
Amardeep1001 in Excel on
0 Replies
freeze panes, freezes more than I select
jhaynie in Excel on
1 Replies