Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Limitations with Pivot Tables
I have created a Pivot Table from some data on an spreadsheet within the same
workbook; one of the columns in my data is basically a string of text, these cells can contain 20 characters or 700 characters; when I create my pivot table and I pull this fields into my pivot table, for some reason the data gets truncated and it is displayed truncated. As an example one of the cells in my data has 379 characters, when pulling this cell into my Pivot Table it only shows 221, does any one know why? Is there any way that I can show all my data? By the way Im using Office 2007. Cheers, Juan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MSDN article on Excel Limitations in Pivot Tables for Multiple consolidation ranges | Excel Worksheet Functions | |||
Pivot table and subtotals - limitations? | Excel Discussion (Misc queries) | |||
Row limitations on Pivot Table in Excel? | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Pivot Table Limitations in 2000 | Excel Worksheet Functions |