I am trying to use a saved Open Data Connection (.ODC) for a Pivot Table in Microsoft Excel (32-bit). In the data screen, I browse and find the data connection I'd like to use, but when I click on the "Always use connection file" checkbox, Excel stops working and restarts. It does it very consistently.
Any thoughts?