Adding column to pivot table data file

[brutus6294]

I've inherited a huge pivottable. If I add a column to the end of a data.xls pivottable data file, should my pivottable be able to recognize the change and make that added column accessible to the Pivot?

I typically would run a crystal report, export to excel. this becomes my data file. I have been successfully using this for my pivot. However I added a column on the data file. In my pivot I have a macro that makes a named range on the datafile. The name range is correctly including the new column. However, when I refresh the pivot, I get 'cannot open pivottable source data file' . Can I not add a column to the data file like this? Thanks..

 

[Gavona]

if the named range includes any extra rows and columns and the pivot table uses the named range as its source (Pivottable wizard, Back to check) then it will pick up the new data when you refresh it. Always has for me.

Gavin

 

[SkipVought]

Hi,

Adding a COLUMN to a PT, raises a slight problem, even of you are using a Named Range. Here's what I do.
[highlight white][tt]
1. Select the PT
2. Activate the PT Wizard
3. BACK to Source data
4. Select A FEW ROWS along with the additional column.
5. Next and Layout.
6. Drag in new column icon.
7. FINISH
8. Activate PT Wizard
9. BACK to Source Data
10. Enter the Range Name
11. FINISH.
[/tt][/highlight]
The Dynamic Range Name works well for changing ROWS.


Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}