Hi Everybody,
Goal first, then my problem.
My goal is to use the PivotTable to display the Vendor & PO# in two columns such as this using the following formula in my Pivot Table: =CONCATENATEX(Table1,[PO#],", "):
My problem is that when I try to move it into the "values" field of my pivot table I receive the error message "This PivotTable field isn't available because it exceeds the total number of characters that a cell can contain."
I am confused as none of the values I entered into that column are over 10 characters, I also received the error message before I added anything to that column. Is Excel counting all characters in the row even though I only want information in once column?
A little Googling led me to this thread in MrExcel: 255 character limit in Pivot Table cell
That led me to try the =LEN function in hopes of teasing out a cell with a really large number of characters. Even though I am not familiar with the =LEN function, I tried this: =LEN([@[PO'#]]) If I understand correctly this will display the number of characters in the respective row in the PO#'s Column. None of the values returned are over 10.
Is there a way to get Excel to realize that none of the values I am entering are over 32767 characters? Or can one of you provide me a workaround to gather this data from my original table?
Thank you for any assistance you can provide!
-Soren
Goal first, then my problem.
My goal is to use the PivotTable to display the Vendor & PO# in two columns such as this using the following formula in my Pivot Table: =CONCATENATEX(Table1,[PO#],", "):
| Vendor | PO# |
| TopCon Medical | 612-A2561 |
My problem is that when I try to move it into the "values" field of my pivot table I receive the error message "This PivotTable field isn't available because it exceeds the total number of characters that a cell can contain."
I am confused as none of the values I entered into that column are over 10 characters, I also received the error message before I added anything to that column. Is Excel counting all characters in the row even though I only want information in once column?
A little Googling led me to this thread in MrExcel: 255 character limit in Pivot Table cell
That led me to try the =LEN function in hopes of teasing out a cell with a really large number of characters. Even though I am not familiar with the =LEN function, I tried this: =LEN([@[PO'#]]) If I understand correctly this will display the number of characters in the respective row in the PO#'s Column. None of the values returned are over 10.
Is there a way to get Excel to realize that none of the values I am entering are over 32767 characters? Or can one of you provide me a workaround to gather this data from my original table?
Thank you for any assistance you can provide!
-Soren
