AutoFilter Column Sort State for Auto Filter Cell or Range Reference Filter Criteria Top 10 Custom Filters Dynamic Filter Color Filter Criteria Icon Filter Filter Column Data Hidden AutoFilter Button Show Filter Button Filter Date Grouping Filter by Blank Calendar Type Filter Value Custom Filter Criteria And Filter Comparison Operator Top or Bottom Value Top Filter by Percent Top or Bottom Value Filter Value Differential Format Record Id Filter By Cell Color Icon Set Icon Id Filter Operator Equal Less Than Less Than Or Equal Not Equal Greater Than Or Equal Greater Than Dynamic filter type Value Max Value Dynamic Filter Null Above Average Below Average Tomorrow Today Yesterday Next Week This Week Last Week Next Month This Month Last Month Next Quarter This Quarter Last Quarter Next Year This Year Last Year Year To Date 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 1st Month 2nd Month 3rd Month 4th Month 5th Month 6th Month 7th Month 8th Month 9th Month 10th Month 11th Month 12th Month Icon Set Type 3 Arrows 3 Arrows (Gray) 3 Flags 3 Traffic Lights 3 Traffic Lights Black 3 Signs 3 Symbols Circled 3 Symbols 4 Arrows 4 Arrows (Gray) 4 Red To Black 4 Ratings 4 Traffic Lights 5 Arrows 5 Arrows (Gray) 5 Ratings Icon Set 5 Quarters Sort Condition Sort by Columns Case Sensitive Sort Method Sort Range Descending Sort By Reference Custom List Format Id Icon Set Icon Id Sort By Value Sort by Cell Color Sort by Font Color Sort by Icon Sort Method Sort by Stroke PinYin Sort None Calendar Type No Calendar Type Gregorian Gregorian (U.S.) Calendar Japanese Emperor Era Calendar Taiwan Era Calendar Korean Tangun Era Calendar Hijri (Arabic Lunar) Calendar Thai Calendar Hebrew (Lunar) Calendar Gregorian Middle East French Calendar Gregorian Arabic Calendar Gregorian Transliterated English Calendar Gregorian Transliterated French Calendar Year Month Day Hour Minute Second Date Time Grouping Date Time Grouping Group by Year Month Day Group by Hour Group by Minute Second Escaped String Cell Reference Cell References Single Cell Reference Reference Sequence Formula Hex Unsigned Integer Unsigned Short Hex Globally Unique Identifier Value URI Extension Calculation Chain Info Cell Cell Reference Sheet Id Child Chain New Dependency Level New Thread Array Comments Authors List of Comments Author Comment Comment Text Cell Reference Author Id Unique Identifier for Comment XML Mapping XML Schema XML Mapping Properties Prefix Mappings for XPath Expressions Schema ID Schema Reference Schema Root Namespace XML Mapping XML Mapping ID XML Mapping Name Root Element Name Schema Name Show Validation Errors AutoFit Table on Refresh Append Data to Table Preserve AutoFilter State Preserve Cell Formatting Unique Identifer Binding to External File Reference to Connection ID File Binding Name XML Data Loading Behavior Connections Connection ODBC & OLE DB Properties OLAP Properties Web Query Properties Text Import Settings Query Parameters Future Feature Data Storage Connection Id Source Database File Connection File Keep Connection Open Automatic Refresh Interval Connection Name Connection Description Database Source Type Reconnection Method Last Refresh Version Minimum Version Required for Refresh Save Password New Connection Deleted Connection Only Use Connection File Background Refresh Refresh on Open Save Data Reconnection Method SSO Id Credentials Method Integrated Authentication No Credentials Stored Credentials Prompt Credentials Connection String Command Text Command Text OLE DB Command Type Local Cube Local Cube Connection Local Refresh Send Locale to OLAP Drill Through Count OLAP Fill Formatting OLAP Number Format OLAP Server Font OLAP Font Formatting Tables XML Source Import XML Source Data Parse PRE Consecutive Delimiters Use First Row Created in Excel 97 Dates as Text Refreshed in Excel 2000 URL Web Post HTML Tables Only HTML Formatting Handling Edit Query URL HTML Formatting Handling No Formatting Honor Rich Text All Parameter Properties Parameter Count Parameter Name SQL Data Type Parameter Type Refresh on Change Parameter Prompt String Boolean Double Integer String Cell Reference Parameter Type Prompt on Refresh Value Parameter From Cell No Value Character Value Index Count of Tables Fields Prompt for File Name File Type Code Page First Row Source File Name Delimited File Decimal Separator Thousands Separator Tab as Delimiter Space is Delimiter Comma is Delimiter Semicolon is Delimiter Consecutive Delimiters Qualifier Custom Delimiter File Type Macintosh Windows (ANSI) DOS Qualifier Double Quote Single Quote No Text Qualifier Text Import Field Settings Count of Fields Field Type Position Text Field Datatype General Text Month Day Year Day Month Year Year Month Day Month Day Year Day Year Month Year Day Month Skip Field East Asian Year Month Day PivotCache Definition PivotCache Records PivotTable Definition PivotCache Source Description PivotCache Fields PivotCache Hierarchies OLAP KPIs Tuple Cache Calculated Items Calculated Members OLAP Dimensions OLAP Measure Groups OLAP Measure Group Future Feature Data Storage Area Relationship Identifier Invalid Cache Save Pivot Records Refresh On Load Optimize Cache for Memory Enable PivotCache Refresh Last Refreshed By PivotCache Last Refreshed Date Background Query Missing Items Limit PivotCache Created Version PivotCache Last Refreshed Version Minimum Version Required for Refresh PivotCache Record Count Upgrade PivotCache on Refresh Stores Cache for OLAP Functions Supports Subqueries Supports Attribute Drilldown PivotCache Field Field Count Shared Items Field Group Properties Member Properties Map Future Feature Data Storage Area PivotCache Field Name PivotCache Field Caption Property Name Server-based Field Unique List Retrieved Number Format Id Calculated Field Formula SQL Data Type Hierarchy Hierarchy Level Database Field Member Property Count Member Property Field Worksheet PivotCache Source Consolidation Source Future Feature Data Storage Area Cache Type Connection Index PivotCache Type Worksheet External Consolidation Ranges Scenario Summary Report Reference Named Range Sheet Name Relationship Id Page Item Values Range Sets Auto Page Page Items Page Item String Count Page Item Page Item String Count Page Item Name Range Set Reference and Page Item Count Field Item Index Page 1 Field Item Index Page 2 Field Item index Page 3 Field Item Index Page 4 Reference Named Range Sheet Name Relationship Id No Value Numeric Boolean Error Value Character Value Date Time Contains Semi Mixed Data Types Contains Non Date Contains Date Contains String Contains Blank Contains Mixed Data Types Contains Numbers Contains Integer Minimum Numeric Value Maximum Numeric Value Minimum Date Time Maximum Date Time Value Shared Items Count Long Text Tuples Member Property Indexes Unused Item Calculated Item Caption Member Property Count Format Index background Color Foreground Color Italic Underline Strikethrough Bold OLAP Members Member Property Index Value Unused Item Calculated Item Caption Member Property Count Format Index Background Color Foreground Color Italic Underline Strikethrough Bold Member Property Indexes Value Unused Item Calculated Item Caption Member Property Count Tuples Member Property Indexes Value Unused Item Calculated Item Item Caption Member Property Count Format Index background Color Foreground Color Italic Underline Strikethrough Bold Tuples Member Property Index Value Unused Item Calculated Item Item Caption Member Property Count Format Index Background Color Foreground Color Italic Underline Strikethrough Bold Member Property Index Value Unused Item Calculated Item Value Caption Member Property Count Range Grouping Properties Discrete Grouping Properties OLAP Group Items Parent Field Base Source Data Set Beginning Range Source Data Ending Range Group By Numeric Grouping Start Value Numeric Grouping End Value Date Grouping Start Value Date Grouping End Value Grouping Interval Values Group By Group By Numeric Ranges Seconds Minutes Hours Days Months Quarters Years Element Group Mapping Index Count No Value Numeric Value Boolean Error Value Character Value Date Time Items Created Count PivotCache Record Future Feature Data Storage Area PivotCache Records Count No Value Numeric Value Boolean Error Value Character Value Date Time Shared Items Index OLAP KPI KPI Count KPI Unique Name KPI Display Name KPI Display Folder KPI Measure Group Name Parent KPI KPI Value Unique Name KPI Goal Unique Name KPI Status Unique Name KPI Trend Unique Name KPI Weight Unique Name Time Member KPI Unique Name PivotCache Hierarchy Hierarchy Count Fields Usage OLAP Grouping Levels Future Feature Data Storage Area Hierarchy Unique Name Hierarchy Display Name Measure Hierarchy Set Parent Set KPI Icon Set Attribute Hierarchy Time Key Attribute Hierarchy Default Member Unique Name Unique Name of 'All' Display Name of 'All' Dimension Unique Name Display Folder Measure Group Name Measures Levels Count One Field Member Value Data Type Unbalanced Unbalanced Group Hidden PivotCache Field Id Field Count Field Index OLAP Grouping Levels Grouping Level Count OLAP Level Groups Future Feature Data Storage Area Unique Name Grouping Level Display Name User-Defined Group Level Custom Roll Up OLAP Group Level Group Count OLAP Group Members Group Name Unique Group Name Group Caption Parent Unique Name Group Id OLAP Group Member Group Member Count Group Member Unique Name Group Entries Sets OLAP Query Cache Server Formats Future Feature Data Storage Area Culture Format Server Format Format Count No Value Numeric Value Error Value Character Value Tuple Count Tuple Member Name Count Field Index Hierarchy Index Item Index OLAP Set Tuple Set Count Tuples Sort By Tuple Number of Tuples Maximum Rank Requested MDX Set Definition Set Sort Order Query Failed Set Sort Order None Ascending Descending Ascending Alpha Alphabetic Order Descending Ascending Natural Natural Order Descending Query Cached Query Count Tuples MDX Query String Calculated Item Calculated Item Formula Count Calculated Item Location Future Feature Data Storage Area Field Index Calculated Item Formula Calculated Member Calculated Members Count Future Feature Data Storage Area Calculated Member Name Calculated Member MDX Formula OLAP Calculated Member Name Hierarchy Name Parent Name Calculated Members Solve Order Set PivotTable Location PivotTable Fields Row Fields Row Items Column Fields Column Items Page Field Items Data Fields PivotTable Formats Conditional Formats PivotChart Formats PivotTable OLAP Hierarchies PivotTable Style Filters Row OLAP Hierarchy References Column OLAP Hierarchy References Future Feature Data Storage Area Name PivotCache Definition Id Data On Rows Default Data Field Position Data Field Header Name Grand Totals Caption Error Caption Show Error Caption for Missing Values Show Missing Page Header Style Name Table Style Name Vacated Style PivotTable Custom String PivotTable Last Updated Version Minimum Refreshable Version Asterisk Totals Show Item Names Allow Edit Data Disable Field List Show Calculated Members Total Visual Data Show Multiple Labels Show Drop Down Show Expand Collapse Print Drill Indicators Show Member Property ToolTips Show ToolTips on Data Enable PivotTable Wizard Enable Drill Down Enable Field Properties Preserve Formatting Auto Formatting Page Wrap Page Over Then Down Subtotal Hidden Items Row Grand Totals Grand Totals On Columns Field Print Titles Item Print Titles Merge Titles Show Drop Zones PivotCache Created Version Indentation for Compact Axis Show Empty Row Show Empty Column Show Field Headers Compact New Fields Outline New Fields Outline Data Fields Compact Data Data Fields Published Enable Drop Zones Stop Immersive UI Multiple Field Filters Chart Format Id Row Header Caption Column Header Caption Default Sort Order MDX Subqueries Supported Custom List AutoSort Reference First Header Row PivotTable Data First Row First Data Column Rows Per Page Count Columns Per Page PivotTable Field Field Count Field Items AutoSort Scope Future Feature Data Storage Area Field Name Axis Data Field Custom Subtotal Caption Show PivotField Header Drop Downs Hidden Level Unique Member Property Compact All Items Expanded Number Format Id Outline Items Subtotals At Top Drag To Row Drag To Column Multiple Field Filters Drag Field to Page Field Can Drag to Data Drag Off Show All Items Insert Blank Row Server-based Page Field Insert Item Page Break Auto Show Top Auto Show Hide New Items Measure Filter Inclusive Manual Filter Items Per Page Count Auto Sort Type Data Source Sort Auto Sort Auto Show Rank By Show Default Subtotal Sum Subtotal CountA Average Max Subtotal Min Subtotal Product Subtotal Count StdDev Subtotal StdDevP Subtotal Variance Subtotal VarP Subtotal Show Member Property in Cell Show Member Property ToolTip Show As Caption Drill State Auto Sort Scope PivotTable Field Item Field Count Item User Caption Item Type Hidden Character Hide Details Calculated Member Missing Child Items Item Index Expanded Drill Across Attributes Page Field Page Item Count Future Feature Data Storage Area Field Item Index OLAP Hierarchy Index Hierarchy Unique Name Hierarchy Display Name Data Field Item Data Items Count Future Feature Data Storage Area Data Field Name Field Subtotal Show Data As Display Format 'Show Data As' Base Field 'Show Data As' Base Setting Number Format Id Row Items Items in a Row Count Column Items Column Item Count Row / Column Item Index Item Type Repeated Items Count Data Field Index Shared Items Index Row Items Repeated Items Count Field Repeated Items Count Field Index PivotTable Format Formats Count Pivot Table Location Future Feature Data Storage Area Format Action Format Id Conditional Formatting Conditional Format Count Pivot Areas Conditional Formatting Scope Conditional Formatting Rule Type Priority Pivot Area Pivot Area Count Conditional Formatting Scope Selection Data Fields Field Intersections Top N Evaluation Type Top N None All Row Top N Column Top N PivotChart Format Format Count Pivot Table Location Rule Chart Index Pivot Format Id Series Format OLAP Hierarchy OLAP Hierarchy Count OLAP Member Properties Members Future Feature Data Storage Area Outline New Levels Multiple Field Filters New Levels Subtotals At Top Show In Field List Drag To Row Drag To Column Drag to Page Drag To Data Drag Off Inclusive Manual Filter Hierarchy Caption Row OLAP Hierarchies Item Count Column OLAP Hierarchies Items Count Hierarchy Usage OLAP Member Property OLAP Member Properties Count OLAP Member Property Unique Name Show Cell Show Tooltip Show As Caption Name Length Property Name Character Index Property Name Length Level Index Field Index Member Item Count Hierarchy Level Hidden Item Name OLAP Dimension OLAP Dimensions Count Measure Dimension Name Dimension Unique Name Dimension Display Name OLAP Measure Group Measure Group Count OLAP Measure Group Measure Group Count Measure Group Name Measure Group Display Name Measure Group Id Dimension Id Table Style Name Show Row Header Formatting Show Table Style Column Header Formatting Show Row Stripes Show Column Stripes Show Last Column PivotTable Advanced Filter Pivot Filter Count Auto Filter Field Index Member Property Field Id Pivot Filter Type Evaluation Order Pivot Filter Id Measure Index Measure Field Index Pivot Filter Name Pivot Filter Description Label Pivot Label Pivot Filter String Value 2 Show Data As Normal Data Type Difference Percentage Of Percentage Difference Running Total Percentage of Row Percent of Column Percentage of Total Index PivotItem Type Data Default Sum CountA Average Max Min Product Count stdDev StdDevP Var VarP Grand Total Item Blank Pivot Item PivotTable Format Types Blank Formatting Drill Type Formula Type Field Sort Type Manual Sort Ascending Descending Pivot Filter Types Unknown Count Percent Sum Caption Equals Caption Not Equal Caption Begins With Caption Does Not Begin With Caption Ends With Caption Does Not End With Caption Contains Caption Does Not Contain Caption Is Greater Than Caption Is Greater Than Or Equal To Caption Is Less Than Caption Is Less Than Or Equal To Caption Is Between Caption Is Not Between Value Equal Value Not Equal Value Greater Than Value Greater Than Or Equal To Value Less Than Value Less Than Or Equal To Value Between Value Not Between Date Equals Date Does Not Equal Date Older Than Date Older Than Or Equal Date Newer Than Date Newer Than or Equal To Date Between Date Not Between Tomorrow Today Yesterday Next Week This Week Last Week Next Month This Month Last Month Next Quarter This Quarter Last Quarter Next Year This Year Last Year Year-To-Date First Quarter Second Quarter Third Quarter Fourth Quarter January Dates in February Dates in March Dates in April Dates in May Dates in June Dates in July Dates in August Dates in September Dates in October Dates in November Dates in December References Future Feature Data Storage Area Field Index Rule Type Data Only Labels Only Include Row Grand Total Include Column Grand Total Cache Index Outline Offset Reference Collapsed Levels Are Subtotals Axis Field Position Rule Type None Normal Data All Origin Field Button Top Right Reference Pivot Filter Count Field Item Field Index Item Index Count Selected Positional Reference Relative Reference Include Default Filter Include Sum Filter Include CountA Filter Include Average Filter Include Maximum Filter Include Minimum Filter Include Product Filter Include Count Subtotal Include StdDev Filter Include StdDevP Filter Include Var Filter Include VarP Filter Shared Items Index PivotTable Axis Row Axis Column Axis Include Count Filter Values Axis Query Table QueryTable Refresh Information Future Feature Data Storage Area QueryTable Name First Row Column Titles Row Numbers Disable Refresh Background Refresh First Background Refresh Refresh On Load Grow Shrink Type Fill Adjacent Formulas Remove Data On Save Disable Edit Preserve Formatting On Refresh Adjust Column Width On Refresh Intermediate Connection Id Query table fields Deleted Fields Sort State Future Feature Data Storage Area Preserve Sort & Filter Layout Next Field Id Wrapped Headers In Last Refresh Minimum Refresh Version Next field id Columns Left Columns Right Deleted Field Deleted Fields Count Deleted Fields Name QueryTable Field Column Count Future Feature Data Storage Area Field Id Name Data Bound Column Row Numbers Fill This Formula On Refresh Clipped Column Table Column Id Grow Shrink Type Insert & Delete On Refresh Insert & Clear On Refresh Overwrite & Clear On Refresh Shared String Table String Item String Count Unique String Count Phonetic Type Half-Width Katakana Full-Width Katakana Hiragana No Conversion Phonetic Alignment Types No Control Left Alignment Center Alignment Distributed Text Base Text Start Index Base Text End Index Run Properties Text Font Character Set Font Family Bold Italic Strike Through Outline Shadow Condense Extend Text Color Font Size Underline Vertical Alignment Font Scheme Text Rich Text Run Phonetic Run Phonetic Properties Font Id Character Type Alignment Revision Headers Revisions Header Last Revision GUID Last GUID Shared Workbook Disk Revisions History Track Revisions Exclusive Mode Revision Id Version Keep Change History Protected Preserve History Revision Row Column Insert Delete Revision Cell Move Revision Custom View Revision Sheet Name Revision Insert Sheet Revision Cell Change Revision Format Revision AutoFormat Revision Defined Name Revision Cell Comment Revision Query Table Revision Merge Conflict Revision Id Revision From Rejection Revision Undo Rejected Sheet Id Map Reviewed List GUID Date Time Last Sheet Id User Name Relationship ID Minimum Revision Id Max Revision Id Sheet Id Sheet Count Sheet Id Reviewed Reviewed Revisions Count revision Id Index Expression Reference 3D Array Entered Value Needed Defined Name Formula Cross Sheet Move Range Defined Name Cell Reference Sheet Id Undo Revised Row Column Revision Format Sheet Id End Of List Reference User Action Edge Deleted Undo Revision Cell Change Revision Format Sheet Id Source Destination Source Sheet Id GUID User Action Sheet Id Old Sheet Name New Sheet Name Sheet Id Sheet Name Sheet Position Old Cell Data New Cell Data Old Formatting Information New Formatting Information Sheet Id Old Formatting Row Column Formatting Change Style Revision Formatting Number Format Id Quote Prefix Old Quote Prefix Phonetic Text Old Phonetic Text End of List Formula Update Formatting Sheet Id Row or Column Formatting Change Style Sequence Of References Start index Length Sheet Id Reference Sheet Id Cell GUID User Action Always Show Comment Old Comment Comment In Hidden Row Hidden Column Author Original Comment Length New Comment Length Formula Old Formula Local Name Sheet Id Custom View Name Function Old Function Function Group Id Old Function Group Id Shortcut Key Old Short Cut Key Named Range Hidden Old Hidden New Custom Menu Old Custom Menu Text Description Old Description New Help Topic Old Help Topic Status Bar Old Status Bar Name Comment Old Name Comment Sheet Id Sheet Id QueryTable Reference Field Id Row Column Action Type Insert Row Delete Row Column Insert Delete Column Revision Action Types Add Delete Formula Expression Type Reference Reference Is Error Area Area Error Computed Area User List User Information Active User Count User Revisions GUID User Name User Id Date Time Worksheet Chart Sheet Dialog Sheet Sheet Properties Macro Sheet Dimensions Macro Sheet Views Sheet Format Properties Column Information Sheet Data Sheet Protection Options AutoFilter Sort State Data Consolidation Custom Sheet Views Phonetic Properties Conditional Formatting Print Options Page Margins Page Setup Settings Header Footer Settings Horizontal Page Breaks (Row) Vertical Page Breaks Custom Properties Drawing Legacy Drawing Reference Legacy Drawing Header Footer Background Image OLE Objects Future Feature Data Storage Area Sheet Properties Dialog Sheet Views Dialog Sheet Format Properties Sheet Protection Custom Sheet Views Print Options Page Margins Page Setup Settings Header & Footer Settings Drawing Legacy Drawing Legacy Drawing Header Footer Future Feature Data Storage Area Worksheet Properties Worksheet Dimensions Sheet Views Sheet Format Properties Column Information Sheet Data Sheet Calculation Properties Sheet Protection Protected Ranges Scenarios AutoFilter Sort State Data Consolidate Custom Sheet Views Merge Cells Phonetic Properties Conditional Formatting Data Validations Hyperlinks Print Options Page Margins Page Setup Settings Header and Footer Settings Horizontal Page Breaks Vertical Page Breaks Custom Properties Cell Watch Items Ignored Errors Smart Tags Drawing Legacy Drawing Legacy Drawing Header Footer Background Image Embedded Controls Web Publishing Items Table Parts Future Feature Data Storage Area Row Full Calculation On Load Base Column Width Default Column Width Default Row Height Custom Height Hidden By Default Thick Top Border Thick Bottom Border Maximum Outline Row Column Outline Level Column Width & Formatting Minimum Column Maximum Column Column Width Style Hidden Columns Best Fit Column Width Custom Width Show Phonetic Information Outline Level Collapsed Cell Span Type Cell Spans Cell Future Feature Data Storage Area Row Index Spans Style Index Custom Format Row Height Hidden Custom Height Outline Level Collapsed Thick Top Border Thick Bottom Show Phonetic Formula Cell Value Rich Text Inline Future Feature Data Storage Area Reference Style Index Cell Data Type Cell Metadata Index Value Metadata Index Show Phonetic Cell Type Boolean Number Error Shared String String Inline String Formula Type Normal Array Entered Table Formula Shared Formula Sheet Tab Color Outline Properties Page Setup Properties Synch Horizontal Synch Vertical Synch Reference Transition Formula Evaluation Transition Formula Entry Published Code Name Filter Mode Enable Conditional Formatting Calculations Reference Worksheet View Future Feature Data Storage Area View Pane Selection PivotTable Selection Future Feature Data Storage Area Window Protection Show Formulas Show Grid Lines Show Headers Show Zero Values Right To Left Sheet Tab Selected Show Ruler Show Outline Symbols Default Grid Color Show White Space View Type Top Left Visible Cell Color Id Zoom Scale Zoom Scale Normal View Zoom Scale Page Break Preview Zoom Scale Page Layout View Workbook View Index Horizontal Split Position Vertical Split Position Top Left Visible Cell Active Pane Split State Pivot Area Pane Show Header Label Data Selection Extendable Selection Count Axis Dimension Start Minimum Maximum Active Row Active Column Previous Row Previous Column Selection Click Count Relationship Id Pane Active Cell Location Active Cell Index Sequence of References Pane Types Bottom Right Pane Top Right Pane Bottom Left Pane Top Left Pane Break Page Break Count Manual Break Count Id Minimum Maximum Manual Page Break Pivot-Created Page Break Sheet View Type Normal View Page Break Preview Page Layout View Apply Styles in Outline Summary Below Summary Right Show Outline Symbols Show Auto Page Breaks Fit To Page Data Consolidation References Function Index Use Left Column Labels Labels In Top Row Link Data Consolidation Functions Average Count CountNums Maximum Minimum Product StdDev StdDevP Sum Variance VarP Data Consolidation Reference Data Consolidation Reference Count Reference Named Range Sheet Name relationship Id Merged Cell Count Reference Cell Smart Tags Cell Smart Tag Reference Smart Tag Properties Smart Tag Type Index Deleted XML Based Key Name Value Relationship id Relationship Id Custom Sheet View Pane Split Information Selection Horizontal Page Breaks Vertical Page Breaks Page Margins Print Options Page Setup Settings Header Footer Settings AutoFilter Settings GUID Print Scale Color Id Show Page Breaks Show Formulas Show Grid Lines Show Headers Show Outline Symbols Show Zero Values Fit To Page Print Area Defined Filtered List Show AutoFitler Drop Down Controls Hidden Rows Hidden Columns Visible State Filter View Type Show Ruler Top Left Visible Cell Data Validation Disable Prompts Top Left Corner (X Coodrinate) Top Left Corner (Y Coordinate) Data Validation Item Count Formula 1 Formula 2 Data Validation Type Data Validation Error Style IME Mode Enforced Operator Allow Blank Show Drop Down Show Input Message Show Error Message Error Alert Text Error Message Prompt Title Input Prompt Sequence of References Data Validation Type None Whole Number Decimal List Date Time Text Length Custom Data Validation Operator Between Not Between Equal Not Equal Less Than Less Than Or Equal Greater Than Greater Than Or Equal Data Validation Error Styles Stop Icon Warning Icon Information Icon Data Validation IME Mode IME Mode Not Controlled IME Off IME On Disabled IME Mode Hiragana IME Mode Full Katakana IME Mode Half-Width Katakana Full-Width Alpha-Numeric IME Mode Half Alpha IME Full Width Hangul Half-Width Hangul IME Mode Conditional Format Type Expression Cell Is Color Scale Data Bar Icon Set Top 10 Unique Values Duplicate Values Contains Text Does Not Contain Text Begins With Ends With Contains Blanks Contains No Blanks Contains Errors Contains No Errors Time Period Above or Below Average Time Period Types Today Yesterday Tomorrow Last 7 Days This Month Last Month Next Month This Week Last Week Next Week Conditional Format Operators Less Than Less Than Or Equal Equal Not Equal Greater Than Or Equal Greater Than Between Not Between Contains Does Not Contain Begins With Ends With Conditional Format Value Object Type Number Percent Maximum Minimum Formula Percentile Conditional Formatting Rule PivotTable Conditional Formatting Sequence of Refernces Formula Color Scale Data Bar Icon Set Type Differential Formatting Id Priority Stop If True Above Or Below Average Top 10 Percent Bottom N Operator Text Time Period Rank StdDev Equal Average Hyperlink Reference Relationship Id Location Tool Tip Display String Formula Type Always Calculate Array Range of Cells Data Table 2-D Data Table Row Input 1 Deleted Input 2 Deleted Data Table Cell 1 Input Cell 2 Calculate Cell Shared Group Index Assigns Value to Name Conditional Format Value Object Color Gradiant Interpolation Conditional Format Value Object Data Bar Color Minimum Length Maximum Length Show Values Conditional Formatting Object Icon Set Show Value Percent Reverse Icons Type Value Greater Than Or Equal Left Page Margin Right Page Margin Top Page Margin Bottom Page Margin Header Page Margin Footer Page Margin Horizontal Centered Vertical Centered Print Headings Print Grid Lines Grid Lines Set Paper Size Print Scale First Page Number Fit To Width Fit To Height Page Order Orientation Use Printer Defaults Black And White Draft Print Cell Comments Use First Page Number Print Error Handling Horizontal DPI Vertical DPI Number Of Copies Id Page Order Down Then Over Over Then Down Orientation Default Portrait Landscape Cell Comments None Print Comments As Displayed Print At End Odd Header Odd Page Footer Even Page Header Even Page Footer First Page Header First Page Footer Different Odd Even Header Footer Different First Page Scale Header & Footer With Document Align Margins Print Errors Display Cell Errors Show Cell Errors As Blank Dash Cell Errors NA Scenario Current Scenario Last Shown Scenario Sequence of References Password Sheet Locked Objects Locked Scenarios Locked Format Cells Locked Format Columns Locked Format Rows Locked Insert Columns Locked Insert Rows Locked Insert Hyperlinks Locked Delete Columns Locked Delete Rows Locked Select Locked Cells Locked Sort Locked AutoFilter Locked Pivot Tables Locked Select Unlocked Cells Locked Protected Range Password Sequence of References Name Security Descriptor Input Cells Scenario Name Scenario Locked Hidden Scenario Changing Cell Count User Name Scenario Comment Reference Deleted Undone Value Number Format Id Cell Watch Item Reference Chart Sheet Properties Chart Sheet Views Chart Sheet Protection Custom Chart Sheet Views Drawing Legacy Drawing Reference in Header Footer Published Code Name Chart Sheet View Sheet Tab Selected Window Zoom Scale Workbook View Id Zoom To Fit Password Contents Objects Locked Paper Size First Page Number Orientation Use Printer Defaults Black And White Draft Use First Page Number Horizontal DPI Vertical DPI Number Of Copies Id Custom Chart Sheet View Chart Sheet Page Setup GUID Print Scale Visible State Zoom To Fit Custom Property Custom Property Name Relationship Id OLE Object OLE ProgId Data or View Aspect OLE Link Moniker OLE Update Auto Load Shape Id Relationship Id Data View Aspect Type Object Display Content Object Display Icon OLE Update Types Always Update OLE Update OLE On Call Web Publishing Item Web Publishing Items Count Id Destination Bookmark Web Source Type Source Id Source Object Name Destination File Name Title Automatically Publish Embedded Control Shape Id Relationship Id Control Name Web Source Type All Sheet Content Print Area AutoFilter Range Chart PivotTable QueryTable Label Ignored Error Sequence of References Evaluation Error Two Digit Text Year Number Stored As Text Formula Formula Range Unlocked Formula Empty Cell Reference List Data Validation Calculated Column Pane State Split Frozen Frozen Split Table Part Count Relationship Id Metadata Metadata Types Collection Metadata String Store MDX Metadata Information Future Metadata Cell Metadata Value Metadata Future Feature Storage Area Metadata Type Information Metadata Type Count Metadata Type Name Minimum Supported Version Metadata Ghost Row Metadata Ghost Column Metadata Edit Metadata Cell Value Delete Metadata Copy Metadata Paste All Metadata Paste Formulas Metadata Paste Special Values Metadata Paste Formats Metadata Paste Comments Metadata Paste Data Validation Metadata Paste Borders Metadata Paste Column Widths Metadata Paste Number Formats Metadata Merge Meatadata Split First Metadata Split All Metadata Insert Delete Metadata Clear All Metadata Clear Formats Metadata Clear Contents Metadata Clear Comments Metadata Formula Assignment Metadata Coercion Adjust Metadata Cell Metadata Metadata Block Metadata Block Count Metadata Record Metadata Record Type Index Metadata Record Value Index Future Metadata Block Future Feature Data Storage Area Metadata Type Name Future Metadata Block Count Future Feature Storage Area MDX Metadata Record MDX Metadata Record Count Tuple MDX Metadata Set MDX Metadata Member Property MDX Metadata KPI MDX Metadata Connection Name Index Cube Function Tag MDX Function Type Cube Member Cube Value Cube Set Cube Set Count Cube Ranked Member Cube Member Property Cube KPI Member Member Unique Name Index Member Index Count Server Formatting Culture Currency Server Formatting String Index Server Formatting Built-In Number Format Index Server Formatting Background Color Server Formatting Foreground Color Server Formatting Italic Font Server Formatting Underline Font Server Formatting Strikethrough Font Server Formatting Bold Font Member Unique Name Index Set Definition Index Sort By Member Index Count Set Sort Order MDX Set Order Unsorted Ascending Descending Alpha Ascending Sort Order Alpha Descending Sort Order Natural Ascending Natural Descending Member Unique Name Index Property Name Index Member Unique Name Index KPI Index KPI Property MDX KPI Property Value Goal Status Trend Weight Current Time Member Index Value String is a Set MDX Metadata String MDX Metadata String Count Single Cells Table Properties Cell Properties Future Feature Data Storage Area Table Id Reference Connection ID Column XML Properties Future Feature Data Storage Area Table Field Id Unique Table Name Future Feature Data Storage Area XML Map Id XPath XML Data Type Style Sheet Number Formats Fonts Fills Borders Formatting Records Cell Formats Cell Styles Formats Table Styles Colors Future Feature Data Storage Area Horizontal Alignment Vertical Alignment Text Rotation Wrap Text Indent Relative Indent Justify Last Line Shrink To Fit Reading Order Border Line Styles None Thin Border Medium Border Dashed Dotted Thick Line Border Double Line Hairline Border Medium Dashed Dash Dot Medium Dash Dot Dash Dot Dot Medium Dash Dot Dot Slant Dash Dot Border Border Count Left Border Right Border Top Border Bottom Border Diagonal Vertical Inner Border Horizontal Inner Borders Diagonal Up Diagonal Down Outline Color Line Style Cell Locked Hidden Cell Font Font Count Fill Fill Count Pattern Gradient Foreground Color Background Color Pattern Type Automatic Index Alpha Red Green Blue Color Value Theme Color Tint Pattern Type None Solid Medium Gray Dary Gray Light Gray Dark Horizontal Dark Vertical Dark Down Dark Up Dark Grid Dark Trellis Light Horizontal Light Vertical Light Down Light Up Light Grid Light Trellis Gray 0.125 Gray 0.0625 Gradient Stop Gradient Fill Type Linear Gradient Degree Left Convergence Right Convergence Top Gradient Convergence Bottom Convergence Color Gradient Stop Position Gradient Type Linear Gradient Path Horizontal Alignment Type General Horizontal Alignment Left Horizontal Alignment Centered Horizontal Alignment Right Horizontal Alignment Fill Justify Center Continuous Horizontal Alignment Distributed Horizontal Alignment Vertical Alignment Types Align Top Centered Vertical Alignment Aligned To Bottom Justified Vertically Distributed Vertical Alignment Number Formats Number Format Count Number Format Id Number Format Code Formatting Elements Style Count Format Format Count Alignment Protection Future Feature Data Storage Area Number Format Id Font Id Fill Id Border Id Format Id Quote Prefix Pivot Button Apply Number Format Apply Font Apply Fill Apply Border Apply Alignment Apply Protection Cell Style Style Count Future Feature Data Storage Area User Defined Cell Style Format Id Built-In Style Id Outline Style Hidden Style Custom Built In Formatting Format Count Font Properties Number Format Fill Alignment Border Properties Protection Properties Future Feature Data Storage Area Number Format Id Font Id Fill Id Border Id Cell Style Format Id Format Id Color Indexes MRU Colors RGB Color Color Alpha Red Green Blue Table Style Table Style Count Default Table Style Default Pivot Style Table Style Table Style Name Pivot Style Table Table Style Count Table Style Type Band Size Formatting Id Table Style Type Whole Table Style Header Row Style Total Row Style First Column Style Last Column Style First Row Stripe Style Second Row Stripe Style First Column Stripe Style Second Column Stipe Style First Header Row Style Last Header Style First Total Row Style Last Total Row Style First Subtotal Column Style Second Subtotal Column Style Third Subtotal Column Style First Subtotal Row Style Second Subtotal Row Style Third Subtotal Row Style Blank Row Style First Column Subheading Style Second Column Subheading Style Third Column Subheading Style First Row Subheading Style Second Row Subheading Style Third Row Subheading Style Page Field Labels Style Page Field Values Style Value Value Value String Value Value Vertical Alignment Run Types Baseline Superscript Subscript Font Scheme Font scheme Styles None Major Font Minor Font Underline Value Underline Types Single Underline Double Underline Accounting Single Underline Accounting Double Underline None Font Name Character Set Font Family Bold Italic Strike Through Outline Shadow Condense Extend Text Color Font Size Underline Text Vertical Alignment Scheme Auto Format Id Apply Number Formats Apply Border Formats Apply Font Formats Apply Pattern Formats Apply Alignment Formats Apply Width / Height Formats External Reference External Workbook DDE Connection OLE Link Supporting Workbook Sheet Names Named Links Cached Worksheet Data Relationship to supporting book file path Sheet Name Sheet Name Value Defined Name Defined Name Refers To Sheet Id External Sheet Data Set Row Sheet Id Last Refresh Resulted in Error External Cell Data Row Value Reference Type Value Metadata DDE Items Collection Service name Topic for DDE server DDE Item definition DDE Name Values DDE Name OLE Advise Data is an Image Value Rows Columns DDE Link Value DDE Value Type DDE Value Types Nil Boolean Real Number Error String OLE Link Items OLE Link Relationship OLE Link ProgID OLE Link Item OLE Name Icon Advise Object is an Image Table Table AutoFilter Sort State Table Columns Table Style Future Feature Data Storage Area Table Id Name Table Name Table Comment Reference Table Type Header Row Count Insert Row Showing Insert Row Shift Totals Row Count Totals Row Shown Published Header Row Format Id Data Area Format Id Totals Row Format Id Header Row Border Format Id Table Border Format Id Totals Row Border Format Id Header Row Style Data Style Name Totals Row Style Connection ID Table Type Worksheet XML Query Table Style Name Show First Column Show Last Column Show Row Stripes Show Column Stripes Table Column Column Count Calculated Column Formula Totals Row Formula XML Column Properties Future Feature Data Storage Area Table Field Id Unique Name Column name Totals Row Function Totals Row Label Query Table Field Id Header Row Cell Format Id Data & Insert Row Format Id Totals Row Format Id Header Row Cell Style Data Area Style Name Totals Row Style Name Array Totals Row Function Types None Sum Minimum Maximum Average Non Empty Cell Count Count Numbers StdDev Var Custom Formula Future Feature Data Storage Area XML Map Id XPath Denormalized XML Data Type XML Data Types String Normalized String Token Byte Unsigned Byte Base 64 Encoded Binary Hex Binary Integer Positive Integer Negative Integer Non Positive Integer Non Negative Integer Integer Unsigned Integer Long Unsigned Long Short Unsigned Short Decimal Float Double Boolean Time Date Time Duration Date gMonth gYear gYearMonth gDay gMonthDays Name Qname NCName Any URI Language ID IDREF IDREFS ENTITY ENTITIES Notation NMTOKEN NMTOKENS Any Type Volatile Dependency Types Volatile Dependency Type Main Type Topic First String Topic Value Strings in Subtopic References Type Reference Sheet Id Volatile Dependency Types Real Time Data OLAP Formulas Volatile Dependency Value Types Boolean Real Number Error String Workbook File Version File Sharing Workbook Properties Workbook Protection Workbook Views Sheets Function Groups External References Defined Names Calculation Properties OLE Size Custom Workbook Views PivotCaches Smart Tag Properties Smart Tag Types Web Publishing Properties File Recovery Properties Web Publish Objects Future Feature Data Storage Area Application Name Last Edited Version Lowest Edited Version Build Version Code Name Workbook View Visibility Minimized Show Horizontal Scroll Show Vertical Scroll Show Sheet Tabs Upper Left Corner (X Coordinate) Upper Left Corner (Y Coordinate) Window Width Window Height Sheet Tab Ratio First Sheet Active Sheet Index AutoFilter Date Grouping Visibility Types Visible Hidden Very Hidden Custom Workbook View Custom View Name Custom View GUID Auto Update Merge Interval Changes Saved Win Only Synch Personal View Include Print Settings Include Hidden Rows & Columns Maximized Minimized Show Horizontal Scroll Show Vertical Scroll Show Sheet Tabs Top Left Corner (X Coordinate) Top Left Corner (Y Coordinate) Window Width Window Height Sheet Tab Ratio Active Sheet in Book View Show Formula Bar Show Status Bar Show Comments Show Objects Comment Display Types No Comments Show Comment Indicator Show Comment & Indicator Object Display Types All Show Placeholders None Sheet Information Sheet Name Sheet Tab Id Visible State Relationship Id Sheet Visibility Types Visible Hidden Very Hidden Date 1904 Show Objects Show Border Unselected Table Filter Privacy Prompted Solutions Show Ink Annotations Create Backup File Save External Link Values Update Links Behavior Code Name Hide Pivot Field List Show Pivot Chart Filter Allow Refresh Query Publish Items Check Compatibility On Save Auto Compress Pictures Refresh all Connections on Open Default Theme Version Update Links Behavior Types User Set Never Update Links Always Update Links Embed SmartTags Show Smart Tags Smart Tag Display Types All None No Smart Tag Indicator Smart Tag Type SmartTag Namespace URI Name Smart Tag URL Auto Recover Crash Save Data Extract Load Repair Load Calculation Id Calculation Mode Full Calculation On Load Reference Mode Calculation Iteration Iteration Count Iterative Calculation Delta Full Precision Calculation Calc Completed Calculate On Save Concurrent Calculations Concurrent Thread Manual Count Force Full Calculation Calculation Mode Manual Calculation Mode Automatic Automatic Calculation (No Tables) Reference Mode A1 Mode R1C1 Reference Mode Defined Name Defined Name Comment Custom Menu Text Description Help Status Bar Local Name Sheet Id Hidden Name Function Procedure External Function Function Group Id Shortcut Key Publish To Server Workbook Parameter (Server) External Reference Relationship Id Relationship Id PivotCache PivotCache Id Relationship Id Read Only Recommended User Name Write Reservation Password Reference Workbook Password Revisions Password Lock Structure Lock Windows Lock Revisions Use CSS Thicket Enable Long File Names VML in Browsers Allow PNG Target Screen Size DPI Code Page Target Screen Size Types 544 x 376 Resolution 640 x 480 Resolution 720 x 512 Resolution 800 x 600 Resolution 1024 x 768 Resolution 1152 x 882 Resolution 1152 x 900 Resolution 1280 x 1024 Resolution 1600 x 1200 Resolution 1800 x 1440 Resolution 1920 x 1200 Resolution Function Group Built-in Function Group Count Name Web Publishing Object Count Id Div Id Source Object Destination File Title Auto Republish