Freeze panes in table and dril down in pivot table
I uploaded an xlsb file to the Sharepoint 2007. The file contains pivot table
tab (with dril down option) along with a raw data tab (with freeze panes).
Upon connexting the file to the excel web services – the drill down option disppears as well as the freeze panes. Any idea if it is possible to overcome this phenomenon?
Thanks.
Drill icons on pivotTables should not disappear, I'm not sure what you mean with "drill down option". The only way to disable drilling is if you disable interactivity on the EWA web part, but it'll be enabled by default. Can you explain what you mean?
Freeze panes are not supported this version. There is no way to get them working unfortunately.
