I have a problem here.
having to choose "Show Pages" from the Pivot Table menu, I was able to display all the pages listed in the PageField. However, it does not show the complete Page name
For eg. in the PageField, it is displayed as 'Operations & Technology' but in the worksheet name, it is displayed as 'Operations & Technolo'. Is there anyway that I can define the worksheet name to be the exact duplicate of the PageField name and not a portion of it only?
pls advise. thx
Bookmarks