![]() |
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