<div>
Hello,<br />
<br />
a few tests with pipe delimited TXT files shows that Excel does not accept this format as a valid connection to create a pivot table. Both Excel 2003 and 2010 allow external data sources as a pivot table source, and you can select the txt file. Excel even starts the wizard for data parsing, but then throws an error.<br />
<br />
So, as far as I have seen it, the answer is: no, you cannot use a pipe delimited text file as a direct data source for a pivot table.<br />
<br />
cheers, teylyn
</div>


<div>
It is possible to use pipe delimited files but csv would be simpler if it's an option.
</div>


<div>
<b>@Teylyn</b>: I don't want any form of wizards to pop up. The design needs to be completely seamless so the end-user doesn't know what's happening in the background. I intend to disable some of the filters to make the report &quot;easy&quot; for beginner Excel users.<br />
<br />
<b>@Rorya</b>: 1) CSV is not an option. The source file is generated by C# code and the development team chose Pipe Delimited as standard. 2) What methods would I use to get the PivotTable to use Pipe Delimited without wizards, error messages etc... i.e. &quot;seamlessly&quot; 
</div>


<div>
Are the users creating the pivots or will they be prebuilt?
</div>


<div>
@ Rorya: Prebuilt.<br />
<br />
DATE &amp;&nbsp;ACCOUNT will be captured from a UserForm. This will retrieve a subset of data from the Server and download the Pipe Delimited Text File.<br />
<br />
The text file will then populate the PivotTable.
</div>


<div>
Excellent! Thank you very much...
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
Quick question. <br />
<br />
I’m currently developing a report model using PivotTables with VBA to hide the filter functionality as majority of end-users are uncomfortable with PivotTables, but I must include drill-down ability for the more experienced end users.<br />
<br />
End-Users will typically have low end machines and poor internet connections. So, source that is transferred as tiny Pipe Delimited Text files that are downloaded from a remote server.
<blockquote>
<b>Is it possible for Excel 2003 to access these text files as a direct source for PivotTables? At present, the data lives a worksheet and I'm aiming to keep filesize to the absolutely minimum.</b>
</blockquote>
Any thoughts?<br />

</div>
</div>


Hi Experts,
Quick question. 

I’m currently developing a report model using PivotTables with VBA to hide the filter functionality as majority of end-users are uncomfortable with PivotTables, but I must include drill-down ability for the more experienced end users.

End-Users will typically have low end machines and poor internet connections. So, source that is transferred as tiny Pipe Delimited Text files that are downloaded from a remote server.Is it possible for Excel 2003 to access these text files as a direct source for PivotTables? At present, the data lives a worksheet and I'm aiming to keep filesize to the absolutely minimum.
Any thoughts?


Can PivotTables Use Delimited Text Files as a Source?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.