Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Pivot Tables
Printing from pivot tables:
I have created quite a complex pivot table using various database queries, everything is great except for printing reports. IS there a way that i acan automate printing reports ie. where the pivot table changes in length the macro will set the pring area, scale to it to best fit and then print. Basically the macro needs to recognise where the bottom right hand corner if the data is and set the print area for this data. Another option that would be very useful is where the drop down menu in the top right hand corner of the pivot table is is it possibel to automate a print function where you can select to print all these reports at once instead of having to go into each one individually and then select All help will be much apreciated TP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing pages from Pivot Tables automatically | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Printing Pivot tables/charts | Charts and Charting in Excel | |||
Pivot Tables & not printing blank rows (revisited) | Excel Discussion (Misc queries) | |||
Pivot Tables & not printing blank rows (revisited) | Excel Worksheet Functions |