Excel workshhet updating macro

20-Aug-2020 12:19

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).