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.