Hi all,
I have been using power pivot for excel for a while now and it's working great. I wanted to publish these on sharepoint and our infrastructure guys have recently made an environment available to me.
Thing is when I upload the files and view them via the Excel Web App in sharepoint I get the all the slicers and filters and whatever data i was showing but the power pivot field list has disappered and I can't find it. If I click on 'open in excel' the file opens locally and I can see the fiedl list as normal.
Can somebody let me know if this is normal? i.e. you have to open it in a local copy of excel with power pivot to see the field list
many thanks..