\<bookmark_value\>DataPilot function; preventing data overwriting\</bookmark_value\>\<bookmark_value\>output ranges of DataPilot tables\</bookmark_value\>

Selecting Pivot Table Output Ranges

Click the button \<emph\>More\</emph\> in the \<emph\>DataPilot\</emph\> dialog. The dialog will be extended.

You can select a named range in which the DataPilot table is to be created, from the \<emph\>Results to\</emph\> box. If the results range does not have a name, enter the coordinates of the upper left cell of the range into the field to the right of the \<emph\>Results to\</emph\> box. You can also click on the appropriate cell to have the coordinates entered accordingly.

If you mark the \<emph\>Ignore empty rows \</emph\>check box, they will not be taken into account when the DataPilot table is created.

If the \<emph\>Identify categories\</emph\> check box is marked, the categories will be identified by their headings and assigned accordingly when the DataPilot table is created.

Open file with example: