Pivot table showed "All" instead of "Multiple items" when using datasource from CSV

**dikchan@hotmail.com** · 08-26-2009, 10:41 PM

I use the following code to get pivot table data source throught ODBC connect to CSV. However, when I chose hide item in "Page" fields, it showed "all" instead of "multiple items". Any expert can help?

Thanks you!

Please Login or Register  to view this content.

**dikchan@hotmail.com** · 08-27-2009, 04:06 AM

noted and revised, Thanks!

**dikchan@hotmail.com** · 08-27-2009, 06:01 AM

Just found the solution in red

With ActiveWorkbook.PivotCaches.Add(SourceType:=xlExternal)
.Connection = "ODBC;DSN=ODBC_CSV;DefaultDir=" & PathName & ";DriverId=27;FIL=text;MaxBufferSize=2048;PageTimeout=5;"
.CommandType = xlCmdSql
.CommandText = Query
.CreatePivotTable SheetName & "!R5C1", TableName, , DefaultVersion:=xlPivotTableVersion10
End With

**romperstomper** · 08-27-2009, 07:26 AM

Actually, the bit in red is irrelevant. You've completely changed how you make the pivot table, which is why it behaves differently!

Pivot table showed "All" instead of "Multiple items" when using datasource from CSV

LinkBack

Thread Tools

Rate This Thread

Display

Pivot table showed "All" instead of "Multiple items" when using datasource from CSV

Re: Pivot table showed "All" instead of "Multiple items" when using datasource from C

Re: Pivot table showed "All" instead of "Multiple items" when using datasource from C

Re: Pivot table showed "All" instead of "Multiple items" when using datasource from C

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions