Repost: Pivot Table - get rid of expand indicators

Similar Threads:

1.getting rid of expand indicators in pivot table

Anyone know how to get rid of the expand indicators (show/hide details) in a pivot table view of a query. Damned annoying and they don't seem to do anything useful. Have tried everything to turn them off but nothing works.

2.OWC 10 Pivot Table - get rid of expand indicators

OWC 10 pivot tables have a propery called DisplayExpandIndicator - and
I expected that it would hide the zillions of + and - expand markers
that are evident in pivot tables. But setting DisplayExpandIndicator
does not do this. What is it supposed to do then? What I am interested
in getting rid of are the spurious + and - markers that appear at
every row and column of a pivot table even when there are no child
cells, ie no point in the markers being shown. They really clutter up
the screen.

3.getting rid of the "Comment Stored as Text" indicator

Those little green triangles in the upper left corner of cells, warning you
that you've got numbers stored as text - is there any way to make them go
away?

Thanks in advance,

Paul

4.Native Excel Pivot Table vs OWC Pivot Table Performance

Questions on this issue regarding OWC10.

1) Is the data retrieve more than can be displayed in one 
IE Window?
2) When scrolling down or across in IE does it take much 
longer the first time and seem relatively quick with 
subsequent scrolling back to the same areas (down and 
across)? 
__________________
-----
Thx
Dan

Quality is not just the absence of defects, but the 
presence of value throughout the entire transaction.


>-----Original Message-----
>I have been experimenting with Pivot Tables connected to 
OLAP cubes,
>and I have noticed a profound difference in performance 
between Excel
>PT and OWC PT
>I am using SQL Server 2000 Standard Edition Analysis 
Server SP 3,
>Office XP Professional with OWC 10.  The same cube 
accessed through
>the OWC is  10 times faster than Excel.
>
>Is this a well known difference, or is there something I 
am doing
>wrong with Excel?  The only thing I can think of is that 
Excel is a
>much heavier application than OWC and adds overhead?  I 
cannot see any
>reason why the same structure and indexes would perform so
>differently.  A pivot table is a pivot table no matter 
where it is
>instaniated, right?  Or in Excel connecting differently 
than OWC
>
>Any help would be appreciated
>.
>

5.OWD Pivot table does not look like Excel Pivot table

Can anyone tell me if there are any properties that can be set to make
the OWC pivot table look like the Excel pivot table?

Thanks,
June

6. Pivot Table Error: Overlapping pivot table reports

7. Hide and show pivot fields in a pivot table

8. Pivot Chart only charting one series when Pivot Table shows two C# and ASP.net