Update of field list PivotTable or PivotChart (Data Access Pages)

F

Filo

Hello,

Design nice PivotTable or PivotChart (selecting fileds,captions,
colors, fonts, order of fieds etc.) sometimes takes more then 1 hour
and I hate when after this my boss (or I self) ask me to add some
additional field not availible in data source ! :(

I can't update field list of PivotTable to new data source without
blanking all object and I have to do stiupid job again (selecting
fileds,captions, colors, fonts, order of fieds etc.) Have you any
solution for mine problem ?

With greeting, Filo.
 

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

PivotTable Field Value List Update 0
Pulling Data From PivotTable 1
Can I alphabetize a PivotTable Field List? 0
Corresponding Data From PivotTable Field List 0
Cannot update "Chart data range:" Field 2
Excel 2007-macro programming logic for data validation 2
Excel 2007-programming macros that apply to data validation 1
Pivottables update source data incorrectly 0

Top