Support for All Tables
You can display any data table in a single-table spreadsheet view by using the Table Name option on the Options tab of the Spreadsheet Preferences dialog box.
The Table Name option is available only for single-table spreadsheet views.
This field contains a list from which you can select a data table that the spreadsheet should use. If you select a different table (for example, change from the Activity table to the Resource table), Open Plan replaces the selection of fields displayed in the spreadsheet with the default set of the new table.
When you change the data table, double-clicking the selection box for an activity on the spreadsheet displays the relevant Details dialog box.
Because all code tables have the same structure, changing between code tables does not affect the columns that are displayed in the spreadsheet.