Hi all
I'm sure this is something simple......but
I have two pivot tables which depending on which criteria I select, change size, one one of them the 'print area' changes size when the pivot changes size and the other doesn't meaning I have to manually change the print area.
The pivots have exactly the same info in and have been set with the same margins etc but for some reason only one of them prints without me having to manually change the print area. As the prints are all macro driven this is causing a real pain.
Any help would be great
regards
Md1
I'm sure this is something simple......but
I have two pivot tables which depending on which criteria I select, change size, one one of them the 'print area' changes size when the pivot changes size and the other doesn't meaning I have to manually change the print area.
The pivots have exactly the same info in and have been set with the same margins etc but for some reason only one of them prints without me having to manually change the print area. As the prints are all macro driven this is causing a real pain.
Any help would be great
regards
Md1