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.
Is there a way to automatically refresh the EWA upon accessing the SP page? I found this link but its for SP 2010. I can't find the 'Excel Services' in the SP Admin Center.