Excel workshhet updating macro
As it stands, we need workarounds to make it happen.Here’s some situations where forcing data refresh or recalculation might be necessary or prudent.
If there isn’t a data connection, add a small one to the worksheet.
When the Query Editor opens, just Close and Load it. Right-click the query, choose properties to see the settings we need. To be tidy, we move the source table (right) onto the same sheet at the loaded query (left).