I have 2 SP Lists exported to an Excel Workbook, which I saved in a library and added an Excel Web Access. The EWA is basically combining data from 2 lists, with. The workbook data connection is set to refresh on open. I also set the EWA to periodically refresh. Tried the EWA menu to Refresh All Connections but the data in EWA didn't refresh.
Atmosfx download