From: Tom Sherwood on
According to the Excel online help, the PivotCache.Connection property can be
set to "the path to and file name of a text file". I tried setting it to the
path and file name of a .csv file and it returned an error. Is there a way to
load a PivotCache directly from a flat file without having to load into a
spreadsheet or database? (The flat file has more than 1 million rows.)
Tom Sherwood