I have set up a pivot table and want to use the show pages option however the
actual page setup is not preserved when you do this - i.e. I have set up the
first page to print as landscape but the subsequent split out of the table
puts everything as portrait - is there any way the formatting can be
preserved when using this option? (I know I can select all tabs and do a
group edit if needed)

Aneela?

There is no setting if that is what you seek. The only way is as you
outline or running code over them

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"AneelaJ" wrote in message
...
I have set up a pivot table and want to use the show pages option however
the
actual page setup is not preserved when you do this - i.e. I have set up
the
first page to print as landscape but the subsequent split out of the table
puts everything as portrait - is there any way the formatting can be
preserved when using this option? (I know I can select all tabs and do a
group edit if needed)