Import Worksheet

The Microsoft File Explorer displays when you click Import on the Budget New Worksheet Form (Posted Adjustment).

Navigate to the desired worksheet and select the file. The file contents displays in the previewer.

Click Open to import the file.

Note: There are several spreadsheet criteria checked before the file can be imported. If any fail the file cannot be imported:
• Comment column (column A) is checked for empty values or 'B'
• The amount columns (budget, comparative) are checked that they contain number or empty
• Check that the column after segment titles column contain numbers
• Check that any totals column contains a formula or is empty
• Check that the spread totals column is empty
The first 100 budget lines are checked. Comment lines are ignored. If there are less than 100 budget lines, all the lines are checked.