The problem is how to dynamically change content (Excel) in Excel Web Access webpart? So F.ex we have 10 users and each of them should see different excel when enter the page. How can I do sth like this?
I can think for two options here:
1. Use Current User Filter web part and connect it to the Excel Web Access web part. Think how to use the data for filtering or whatever is useful for your data
2. If the user won’t grow – create different groups and show/hide web parts (or pages) using Target Audience feature.
Hope this helps.
Please remember to indicate if the question/comment has been answered or is helpful.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.