locked
Pivot table field is truncated if >255 characters if pivots use connection string RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I have an Excel 2013 workbook containing pivot tables.  The Pivot tables get their data from a separate Excel workbook, via a connection string (Provider=Microsoft.ACE.OLEDB.12.0;, etc).  If I were to insert a pivot table into the source document, the pivot field contains all characters in the description field.  However, in the separate file format described above, the description is truncated.  Anything that needs entered into the connection string to avoid this?  Thanks, Charles
    Tuesday, July 21, 2020 10:57 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Refer to this article and check if this will help you:

    https://www.accountingweb.com/technology/excel/how-to-skirt-the-255-character-limit-within-excel-pivot-tables

    Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

    This “Excel IT Pro Discussions” Forum will be migrating to a new home on Microsoft Q&A, please refer to this sticky post for more details.

    Regards,

    Emi Zhang

    "Office" forums will be migrating to a new home on Microsoft Q&A !
    We invite you to post new questions in the "Office" forums' new home on Microsoft Q&A !

    Wednesday, July 22, 2020 6:32 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for your reply.  I read through the article and set up a test case.  i think my fields had 855 characters.  I used this test case as the source for a pivot, which is in a separate file and via a connection string, all 855 characters were there in the new pivot. 

    However, i established a new connection in the same workbook, that references the real data i want to pivot.  Again, it chopped it off at 253 characters. 

    Thursday, July 23, 2020 11:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    How about using Power Query to create the connection? Did you test with Power Query?

    Regards,

    Emi Zhang

    "Office" forums will be migrating to a new home on Microsoft Q&A !
    We invite you to post new questions in the "Office" forums' new home on Microsoft Q&A !

    Wednesday, July 29, 2020 9:09 AM