At the moment when you export to a Dynamic Worksheet (Excel) you cannot refresh the data as this leads to all the contents of the file disappearing.

There is a "workaround" where you must edit the connection properties, an error is displayed and on closing the window and refreshing the data is displayed, but this is not acceptable for users who need to open the file several times a day.

Previously users were using Excel sheets connected to a SharePoint list, and they had no problems refreshing data so this is a regression for our users.