I am fairly new to SharePoint.
I have created an Excel sheet that contains a filter.
This filter displays only rows containing a date that is in this week and the upcoming week.
I am using this excel sheet in an Excel services web part on SharePoint 2010 Enterprise.
However, the filter is statically applied to the Excel sheet. Only when the Excel file is changed, the web part is updated.
How can I make sure that the filter is always reapplied by Excel services, so the rows displayed in the web part are always up-to-date?
(always display rows containing dates of current and upcoming week)
View Complete Post