Spreadsheet View Related Topics: Spreadsheet View Overview Spreadsheet views display information for multiple records in a tabular format. Audit Remaining Work View When you have remaining work that is critical, you can use the Audit Remaining Work view to look at incomplete work grouped by float to review the activities with negative float. Predecessor/Successor Spreadsheet This spreadsheet allows you to view multiple relationships for each activity in a project. Customizing of a Spreadsheet View This topic discusses how to customize a spreadsheet view. Subprojects in Spreadsheet Views In a spreadsheet view (or in the spreadsheet pane of a barchart view), you can convert an activity into an internal subproject by adding an activity with an ID that indicates that it is a child of the subproject. Splitting a Spreadsheet View into Two Panes Open Plan allows you to split the view into two panes in order to “freeze” the columns displayed in the left pane. 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. Grouping in the Spreadsheet View You can define groups for the spreadsheet portion of a barchart view as well as for stand-alone spreadsheet views. Outlining in the Spreadsheet View Outlining is a feature available in spreadsheet views, including the spreadsheet portion of the barchart view. Linking Although you can use calculated fields to display individual fields from different data tables on a single spreadsheet, Open Plan offers a more general linking capability in multi-table spreadsheet views. Resource/Activity Spreadsheet The Resource/Activity spreadsheet allows you to view multiple assignments for each resource. Modifying Hierarchical IDs using Indent and Outdent Open Plan allows you to quickly modify hierarchical IDs for activity, resource assignment, and code assignment spreadsheets by using the Indent and Outdent commands. Automatic Numbering within a Spreadsheet Activity IDs and resource IDs can be generated automatically from within a spreadsheet view. Spreadsheet Keyboard Shortcuts The effect of using keyboard shortcuts depends on the type of field that has focus. Tabs and Dialog Boxes Related Procedures Parent Topic: Views and Reports
