Thread: Periodic Refresh of Spreadsheet in SharePoint Excel Services Web Part

Hi all,

I have an excel spreadsheet that gets its data from SharePoint views. I display the spreadsheet in an Excel Services Web Part on a SharePoint site. The only time the spreadsheet refreshes is when I open it in Excel, then save it back to the site.

I see that in the web part configuration there is a tick box entitled "Periodically Refresh if Enabled in Workbook". I have ticked that box, but it doesn't periodically refresh. So I opened it in Excel to see where I enable that. I found a tick box under Data, Connections called "Refresh every" with a box beside it to specify the number of minutes between refreshes. Sadly, this box is greyed out, so I can't seem to "Enable [periodic refresh] in Workbook".

Any ideas?

Thanks,
Mike