One or more ranges of cells that you designate to print when you don't want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed.
Row or column labels that are printed at the top of or on the left side of every page on a printed worksheet.
Independent attributes associated with items, or members, in an OLAP cube. For example, if city items have size and population properties stored in the server cube, a PivotTable report can display the size and population of each city.
To make settings for a worksheet or workbook that prevent users from viewing or gaining access to the specified worksheet or workbook elements.
A field that's used to filter a subset of data in a PivotTable or PivotChart report into one page for further layout and analysis. You can either display a summary of all items in a report filter, or display one item at a time, which filters out the data for all other items.
You use a query channel in a DDE conversation between the destination application and a specific query (for example, Query1) in Query. To use a query channel, you must have already opened the query window using a system channel.
All elements included in the Query window, such as tables, criteria, the order in which fields are arranged, and so on. The design also specifies whether Auto Query is turned on, and whether you can edit the source data.
A setting that allows a file to be read or copied but not changed or saved.