C

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y]

calculated fields
     activating
     calculation rules 2nd
     creating 2nd 3rd
         case study 2nd 3rd 4th
         inserting calculated fields into pivot tables 2nd
         manually adding to data sources
         via formulas outside of pivot tables 2nd
     deleting 2nd
     formulas, documenting 2nd
     in VBA 2nd
     naming
calculated fields (OLAP cubes)
calculated items 2nd
     activating
     calculation rules 2nd
     creating
         case study 2nd 3rd 4th
     deleting 2nd
     formulas, documenting 2nd
     hiding
     in VBA 2nd
     naming
     solve order, changing
calculation options (VBA pivot tables)
     BaseField property 2nd
     xlPercentDifferenceFrom property 2nd
     xlPercentofTotal property
calculations
    rules
         calculated fields 2nd
         calculated items 2nd
         cell references
         constants
         named ranges
         order of operator precedence 2nd
         referencing totals
         worksheet functions
Cannot group that selection error messages, troubleshooting 2nd
captions
     in VBA pivot tables
case studies
     building pivot tables with external data sources 2nd 3rd 4th 5th
    calculated fields
         creating 2nd 3rd 4th
     calculated item creation 2nd 3rd 4th
     data source preparation for pivot table reports 2nd 3rd
     life after pivot tables 2nd
     multiple consolidation range picot tables 2nd 3rd
     order lead-time reports 2nd 3rd
     pivot table creation 2nd 3rd
     pivot table reporting systems, creating 2nd
         external data sources, creating 2nd 3rd
         importing results
         queries, creating/formatting pivot tables 2nd
         queries, defining 2nd
         report refreshing macro, creating 2nd
    pivot table reports
         formatting 2nd
     pivot table synchronization via macros 2nd 3rd 4th 5th
    pivot tables
         creating/formatting 2nd 3rd 4th
     revenue by line of business reports 2nd 3rd
     summary reports circa 1992 2nd 3rd 4th
    VBA pivot tables
         creating in Excel 97 2nd
cell references
     in calculations
cells
    blank cells
         in VBA pivot tables 2nd 3rd
    empty cells
         in row fields, filling 2nd 3rd 4th
     formatting 2nd
     importance, tracking in seasonality reports 2nd
changing
    default number format
         in VBA pivot tables 2nd
     summary calculations
         blank cells causing counts
     VBA pivot tables
Choose Data Source dialog (PivotTable Wizard)
     OLAP Cubes tab
Code window (VBA Editor)
column areas
Column fields
     multiple consolidation range pivot tables
column headings (data sources)
     unique headings
columns
     adding to pivot tables
     repeating groups as
     selecting as ranges in data sources
combining
     OLAP cubes 2nd
command buttons (Forms toolbar)
     assigning macros to
comments
     in VBA
company division revenue contribution reports 2nd
comparing
    lines
         in seasonality reports
configuring
     macro security settings
constants
     calculation rules
converting
     pivot tables to hard data
     VBA pivot tables to reports
copying
    pivot table referencing formulas
         troubleshooting 2nd
Count function
Count Nums function
counts
     due to blank cells
Create New Data Source dialog (PivotTable Wizard)
     local OLAP cube connections
CreatePivotTable method (VBA)
     pivot tables, building
cross-style mouse pointers
Custom option (Subtotals dialog) 2nd
customizing
    fields
         field names
         reasons for
    pivot charts
         permanancy of changes 2nd
    pivot table toolbar
         for custom formatting
     VBA pivot table worksheets