Refresh settings allow you to configure Excel Add-ins behavior when refreshing data.
Confirm 'Refresh' action
Determines whether to display the confirmation dialog box when you refresh data on the current worksheet.
Confirm 'Refresh All' action
Determines whether to display the confirmation dialog box when you refresh data on all worksheets in the current workbook.
Keep table if exists
Determines whether to re-create an Excel table with imported data or to keep an existing one when refreshing data.
Keep table sorting
Determines whether to keep sorting settings in the Excel table with imported data when refreshing data.
Keep hidden columns
Determines whether not to unhide hidden columns when refreshing data.