-
this should just be part of the data connection options
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. -
What ifyou used power query lastrefresh? Would that help as in, "were these records here when last refreshed?"
You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
duncs
Chalfie
@aggi
Any suggestions on how to get a table that updates each time a spreadsheet is opened.
Basically want a table that reflects new data that has been input into another sheet. The other sheet has a unique, key column which I feel could be useful.
Effectively each time I open it I want to clear out the existing data and replace with anything that has been newly input in the source worksheet. Data only gets added at the bottom of the source workbook.
I could do it with a macro but that would be quite convoluted (it's to integrate into a flow and they can't use macro enabled workbooks). Am I missing anything or should I just bite the bullet and take that approach?