We have a labelling software that looks at Excel sheets to generate
labels.

I have recently made a simple MS Query to look at our company database
for the live information.

But can the sheet refresh when closed? Is it specific enough to ask
whether a sheet is "opened" or refreshed when another sheet or
software reads from it?

Or are we stuck manually opening and refreshing the sheet manually on
a daily basis?

Any thoughts much appreciated.
Thanks.