Skip to Content
0
Former Member
Mar 14, 2007 at 05:51 PM

Multiple Queries in Workbook (2004s)

33 Views

Hello,

I have read similar questions a couple of times now, but still I didnt see a complete answer.

I want to add a query to a workbook, which I created with the standard 2004s template. I saved the workbook, added a new worksheet with Excel functionality and what I have read now is, that with the "Design Toolbox" I can add Analysis Grid, Navigation pane etc.

That is all quite nice, but I dont want to do that all one after another and maybe for a couple of worksheets.

What I am looking for is a) a function to copy the complete set of design items from the first worksheet (with the standard layout) to all other worksheets

or b) a function to insert a query in the worksheet which then automatically loads the standard layout.

I can not find any of it. Please help

Regards

Daniel