View, insert, re-order, copy, update, and create PDF or XPS files for selected sheets in the workbook.
The working papers created for the financial reports can represent a lot of sheets in the workbook. Managing these sheets from the worksheet tabs at the bottom of Excel can be tedious and time consuming.
The ExcelFSM Sheets Manager allows to see all the sheets at one glance. The Sheets Manager dialog is movable and resizable. The bigger you make the window, the more sheets are visible.
Simply click on a sheet to make this sheet active.
•Click Insert to insert a sheet before this active sheet
•Click Move to move the active sheet, by selecting the sheet to move it before and then click move again.
•Click Copy to make a copy of the active sheet
To delete sheet(s), check the desired sheet(s), then click Delete.
To create a PDF or XPS file, check the desired sheet(s), then click the Create PDF or XPS button.
To rename the active sheet, use the tag at the bottom of Excel and right click - Rename.
Working Papers auto update
When changes are made to a financial report, the related Working Papers are automatically updated the next time the sheets become active. For some working papers, this updating process takes few seconds, and for that reason, the automatic updated is not the default for the working papers. To make it the default, the checkbox '_WP auto update' in the 'Sheets Manager' must be checked.
If not checked, when changes are made to a financial report, the tag of the related Working Papers are colored in red to indicate that the working paper is not up to date. Clicking the update button will update the working papers with tag colored in red.