Excel is sending an MDSCHEMA_PROPERTIES DISCOVER command with a request for <PROPERTY_TYPE>2</PROPERTY_TYPE> at the level of the database. Since the request is being made at the database level rather than the cube level, it causes all cubes contained in the database to be loaded and the calculation script for each executed. That also results in any associated security expressions being evaluated for each cube contained in the database.
For existing PivotTables select the PivotTable. Select Connection Properties from the PivotTable Tools | Options | Data | Change Data Source ribbon.
In the Connection Properties dialog unselect Number Format, Fill Color, Font Style & Text Color from the OLAP Server Formatting options. Click OK to apply the settings.
To automate turning off the formatting for all connections in a workbook you can use a VBA macro similar to the following:
For Each cn In ActiveWorkbook.Connections
.ServerFillColor = False
.ServerFontStyle = False
.ServerNumberFormat = False
.ServerTextColor = False
Raksta ID: 2535767. Pēdējo reizi pārskatīts: 2012. gada 1. nov.. Pārskatījums: 1