| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable template is truncating data
I created a PivotTable template and it is truncating data. When I import
3400 lines of data and refresh my template, it truncates at 311 lines. Any ideas what is causing it? I am working in Excel 2007 but had a similar problem in 2003. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
PivotTable template is truncating data
Hi
Have you checked that the pivot table range is picking all the data up. It mayb set to pick up Sheet1a1:B311 etc Wendy wrote: I created a PivotTable template and it is truncating data. When I import 3400 lines of data and refresh my template, it truncates at 311 lines. Any ideas what is causing it? I am working in Excel 2007 but had a similar problem in 2003. -- Matt Lynn Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200909/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked cell truncating data | Excel Discussion (Misc queries) | |||
| Truncating data in drop down list | Excel Worksheet Functions | |||
| Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
| truncating data within a cell for an entire column | New Users to Excel | |||
| Exported File truncating cell data after 255 characters | Excel Discussion (Misc queries) | |||
Linear Mode
