Process Multiple Worksheets
Budget Loader workbooks can contain/process multiple worksheets. The worksheets can be of either Budget Loader type during multi-process, planning or history or a combination.
When posting, you may wish to post one, all, or specific, individual worksheets in your workbook. You could use this feature to have Budget Loader ignore a worksheet which contains all your calculations which then feeds the posting worksheet(s) via formulas.
From the Budget menu,
- Choose the Sheet Selection item. The screen below appears.
- Choose which worksheets you wish to process.
- Optionally, choose Stop on First <SAP> Error and not attempt to post any subsequent sheets if any errors are found.
- S elect OK. You may also use the filter to the left to limit the display to one type of Budget Loader template.
To process your selection
From the Budget menu,
- Choose the Multi-Sheet Process menu item. The Multi-Sheet Settings window appears.
- Select appropriate option and continue.
If you select Use Current Settings and Don’t Ask Again you will not be prompted, in this session of Budget Loader again.
If you select Review or Change Current Settings you will be taken to the sheet selection dialog before processing continues.