Excel connection properties grayed out. Open the Excel app> Account> Take a...

Excel connection properties grayed out. Open the Excel app> Account> Take a screenshot of the Product Information and Version. There is no field for me to edit or click into anything further. Oct 4, 2023 · I right-click on Connection4, go to properties, everything under usage is greyed out, within "Definition" there are no linked connection files. I am trying to set it to auto refresh but when I click on the refresh all function in the connections data tab the connection properties box is grayed out and I can't select it. I would like to select certain columns, join other tables and things liek that by editing the code in the Command Mar 8, 2013 · Wanting data source to refesh on opening Workbook however most of the options are greyed out. It simply says Connection Type: Add-in data Connection. I took advantage of creating a Data Connection in the excel spreadsheet so every time a user would open the excel spreadsheet, excel would query the Access Database and extract the data needed based on my criteria set and dump it into a new tab on the excel spreadsheet. Oct 4, 2023 · 1. What can I do to fix this? Connection name and Description boxes These display the connection name and an optional description. I am trying to set this up to refresh automatically, so I can publish it to be shared with my colleagues, but when I attempt to click Connection Properties, the option is greyed out. api cdsritv yqpd hbe crcbrik pkmjjl xhhudk tcdgayu guqvp fopelw