For convenience, you can add sheets to an existing .gwb workbook or Excel file without having to open that file. This lets you collate the output from a sequence of related analyses, adding each spreadsheet in turn when you’ve finished working with it.
Your spreadsheet will be added to the existing book, but will also remain open in Genstat so that you can continue working with the data. This lets you take multiple ‘snapshots’ of a spreadsheet, saving each set of analyses on a separate sheet within the same workbook. The added spreadsheets will all have the same name but will have an underscore and incrementing number appended to them e.g. _1, _2, etc.
- From the menu select Spread | Export. or Spread | Sheet.
- Select either Add to Excel file or Add to Book (GWB) file.
- Navigate to your file then click Open.
Your current spreadsheet will be added to the closed file, but will also remain open in Genstat so that you can continue working on it.