Hello, I hope everyone is well. I am building a warehouse pick sheet. It's pretty straightforward and I only have one non-google or non-youtube question.
The main pivot table print settings has rows 1-3 as print titles.
The only other setting is to print all columns on one page.
The print preview shows it set up properly.
When I use the Pivot Table Analyse > Options > Show Report Filter Pages (the report filter is by tech name so each person has his/her own pick sheet) I get about 200 brand new pivots that is a huge time saver. But, none of them have the print setting as set in the Main Pivot. Is that normal? I understand that each is a new separate pivot table on it's own tab. Does that mean I need to find a "global" print setting? Any pointers or insight appreciated.
The main pivot table print settings has rows 1-3 as print titles.
The only other setting is to print all columns on one page.
The print preview shows it set up properly.
When I use the Pivot Table Analyse > Options > Show Report Filter Pages (the report filter is by tech name so each person has his/her own pick sheet) I get about 200 brand new pivots that is a huge time saver. But, none of them have the print setting as set in the Main Pivot. Is that normal? I understand that each is a new separate pivot table on it's own tab. Does that mean I need to find a "global" print setting? Any pointers or insight appreciated.