Hi All,

Just a quick question can you tell me if 16 worksheets is the maximum of sheets that is assigned to any one workbook, or financial statement.

I know you can do page breaks in any worksheets a number of times over but a client wanted each department on a worksheet of it's own but has 16 and is unable to create another. The option simply isn't there. It says delete worksheet but no option to insert as usual.

Hi GT,

You are correct 16 is the maximum number of tabs (worksheets). See here for more information http://softrak.com/ubbthreads/ubbthreads...lts_f#Post44128

Lauren

Thanks

Hi Ishana,

Rather than have each department on a separate sheet, you should only need one sheet and then select the department you want to view from the department drop down.

You can also create a statement group that will print each of them in turn for a combined set.

Having each department on a separate tab is the way you would do this in Excel, where there is no way to just "toggle" the department.