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!