ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple Pivot tables using the same source data (https://www.excelbanter.com/excel-discussion-misc-queries/183124-multiple-pivot-tables-using-same-source-data.html)

Rhiannon McKay

Multiple Pivot tables using the same source data
 
I'm using the same source data for multiple Pivot tables but when I get to
the 3rd one, the dialog box that Excel shows is too small to read the entire
names it generates so I can't tell which one I need to pick. The name starts
with the file name and the sheet name with the source range is so far to the
right it doesn't display. I have been unable to find a way to enlarge the
box or have it just display the sheet name and range instead of the whole
file name, etc. Has anyone else come across this and found a solution? I'm
working all in the same file, so the file name, which I can see, is useless
information. Thanks!


All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com