Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extending Field Size in Pivot Tables
Hi -
I have been conducting interviews and some of the responses are long. I have tried to put them in a pivot table but there seems to be a field size limit. (By the Way, MS Access is not available). Is there a way I can either extend the field size which would be my preference or can you suggest a different way? Using the lookups as a formula are overwhelming the size of my file. Thanks Carrie -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extending Field Size in Pivot Tables
Hi,
A little more detail might help what is the structure of your pivot table, what is the error message you are getting, what do you long fields contain and how long are them? What version of Excel are you using. And maybe, why do you want a monster text field in a pivot table? -- Thanks, Shane Devenshire "Carrie_Loos via OfficeKB.com" wrote: Hi - I have been conducting interviews and some of the responses are long. I have tried to put them in a pivot table but there seems to be a field size limit. (By the Way, MS Access is not available). Is there a way I can either extend the field size which would be my preference or can you suggest a different way? Using the lookups as a formula are overwhelming the size of my file. Thanks Carrie -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extending Field Size in Pivot Tables
Hi again,
I have tested 2003 and 2007. 2003 allows 254 characters in a field, 2007 allows 32,310. So one solution would be to upgrade another would be to create a formula outside the pivot table to retrieve the desired information into a regular spreadsheet cell. -- Thanks, Shane Devenshire "Carrie_Loos via OfficeKB.com" wrote: Hi - I have been conducting interviews and some of the responses are long. I have tried to put them in a pivot table but there seems to be a field size limit. (By the Way, MS Access is not available). Is there a way I can either extend the field size which would be my preference or can you suggest a different way? Using the lookups as a formula are overwhelming the size of my file. Thanks Carrie -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value Field Settings for Pivot tables | Excel Worksheet Functions | |||
Value Field Name is lost in Pivot Tables... | Excel Discussion (Misc queries) | |||
Page field in pivot tables | Excel Discussion (Misc queries) | |||
Calculated field in Pivot Tables | Excel Discussion (Misc queries) | |||
How do I unlimit field size in using Excel Pivot Tables? | Excel Discussion (Misc queries) |