Angeljurich15
New Member
- Joined
- Jan 23, 2020
- Messages
- 5
- Office Version
- 2013
- Platform
- Windows
So I am using a pivot table and one of my rows contains quite a lot of wording.
After I select from the filter which option I want, I go to the row that contains the long wording and edit the wording at the top. Then, when I'm done typing it out, it shortens it to so many charaters (I'm assuming it's the weird 255 charters only rule).
Key point: I want to be able to edit the wording on the pivot table and not have to go back to the source table to do so.
It does edit the text but will only allow a limited number of characters in the cell.
Is there a VBA code that will allow my pivot table to have more characters within the cell?
After I select from the filter which option I want, I go to the row that contains the long wording and edit the wording at the top. Then, when I'm done typing it out, it shortens it to so many charaters (I'm assuming it's the weird 255 charters only rule).
Key point: I want to be able to edit the wording on the pivot table and not have to go back to the source table to do so.
It does edit the text but will only allow a limited number of characters in the cell.
Is there a VBA code that will allow my pivot table to have more characters within the cell?
