Hello Joe,
.
Unfortunately, there won't be a fix to this issue at least any time soon. This is the result of the Outlook Client deprecation. This whole feature would need to be retooled from a DEV standpoint.
Here are the steps to take to get the refresh to work which it looks like you have already seen:
docs.microsoft.com/.../export-excel-dynamic-worksheet
The main issue here will be this url in step 3:
We will want it to look like above with the "tweener" information. Sometimes, this will be showing a url for the error message you would get in step 5 below:
The url gets corrupted if you hit "ok" on this page and then hit "import". The url then is replaced with this error message url instead. There is no way to change or fix this, so you would need to re-export the file to Excel, then when you are prompted for credentials and hit the above error page (this is a good thing). You instead will just close out this error window and then you should be able to refresh the data.
Thanks,
Tyson
