MS Excel / VBA help thread

You are reading a single comment by @aggi and its replies. Click here to read the full conversation.

•

duncs in reply to @aggi

this should just be part of the data connection options

https://support.microsoft.com/en-us/office/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440

Set refresh options when you open or close a workbook You can refresh
an external data range automatically when you open the workbook. You
can also save the workbook without saving the external data to shrink
the size of the file.

Select a cell in the external data range.

Select Data > Queries & Connections > Connections tab, right click a
query in the list, and then select Properties.

In the Connection Properties dialog box, on the Usage tab, under
Refresh control, select the Refresh data when opening the file check
box.

If you want to save the workbook with the query definition but without
the external data, select the Remove data from the external data range
before saving the workbook check box.

•

aggi in reply to @duncs

Cheers but I can't see an option to only show new data. So far as I can tell the only option is to refresh and all data will appear in the table. I could add a query but can't think of how I'd filter it.

@Chalfie I tried that out but when I refresh the refresh date for all data in the table becomes the last refresh date so can't think of how I'd use it.

About

@aggi started