External Data Range Properties
I have a workbook that refreshes each time it is opened using the File menu Data -> Import External Data.
When I save the spreadsheet I want to break the link to the csv file, I would like to do it via a macro/VBA. Unselect the below, rather than have the user select data properties and manually untick the save query definition
External Data Range Properties -> Query Definition - >Save Query Definition
Is this possible