Expand the fields used in a Datasource for a Pivot Table

S

scott56hannah

Hi,

I have created a series of Pivot Tables and Charts that use external CSV
files via a Datasource. The reports have worked well as it is simple to add
new data to the CSV files and then update the Pivot Tables and Charts by
refreshing.

i have now struck a problem where I want to expand the fields used in the
existing Datasources to include new fields.....I have searched everywhere I
can think of and can find no reference to assist in doing this ? Is it
possible ? or do I need to recreate the Datasource from scratch and then
Pivot Tables and Charts to take advantage of the new fields...

Any help appreciated....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Setting column width in a table with a macro is not working 0
Pivot Table with MS Access as DataSource 1
Pivot table 0
Slicers and Calculated Items in Pivot Table 2
determine in datasource or pivot table 0
Refresh Pivot table without losing the format 4

Top