Using file export and import to update worksheets

If you need to make changes to a lot of items in worksheets 251, 261, 303, 304, 308, 330, 340, or 351 in Central Manager, you may find it easier to export the items to a Microsoft Excel spreadsheet, make the changes in the spreadsheet, and then import the spreadsheet back into Central Manager.

Pre-requisites: You have created a worksheet (saved to Worksheets | Worksheets Status) and its Status is Not Yet Approved.

To export worksheet items to a spreadsheet:

1. Open a worksheet that you created previously.
2. On the Contents tab, right-click in the grid and select Export.
3. Type a File Name for the spreadsheet.
4. Select the file type (Tab delimited, Comma delimited, XML).
5. Click Browse and select the location where you would like to save the spreadsheet.
6. Click Save.
7. Click OK.
8. Click OK. You can now open the spreadsheet in Excel and make any changes necessary.

To import the spreadsheet into Central Manager:

1. Open the worksheet.
2. On the Contents tab, right-click in the grid and select Import.
3. Click Browse, go to the location where you saved the spreadsheet, and select it.
4. Click Open.
5. Click OK.
6. Click OK. The worksheet data is overridden by the data in the spreadsheet.