umm, this is a little embarrassing to ask, but does anybody know how I got my Excel Ribbon, shown below, to display? This was the first Excel Services report I ever published (Excel 2007/SharePoint 2010 W/PerformancePoint), and it just appeared. I just published my second ever report, and that ribbon is not there. I have tried to compare the PivotTable Options between the two reports and I'm not seeing anything that looks like it would be the culprit.
Are both of these two Excel file from Excel 2007? have you uploaded the file to the same place? to your this special scenario, I would recommend you delete this file, then create a PowerPivot Gallery, lastly deploy the Excel workbook into this location from client Excel file rather than upload the file directly.
If the issue still exist, please feel free to let us know.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
OK, sounds like there may be a couple of learning opportunities on my end...the Office Suite on my local PC that I develop on is Office 2007; however, our Production SharePoint site that I publish to is 2010...so I guess it's Office extensions would be 2010 as well? Even so, if I developed/published both of the reports in the same manor (as far as I can tell), shouldn't I see the same end results?
And regarding PowerPivot, I must confess that I don't really know anything about it. I just assumed it was a third-party add on that would cost money to use, and I've not had an opportunity to evaluate it yet. I'm just getting my feet wet in Analysis Services and still have a lot to learn...