Hello
If you create a Pivottable from a range and then click "More tables" in the pivottable list of fileds, this add the data range to the data model.
But it looks like it is not possible to modifie this range source : new lines are not taken in account when updating Powerpivot table, no connection is defined, no link appears.
Does anyone knows how to chage this range source definition ? Thanks.
Chris
If you create a Pivottable from a range and then click "More tables" in the pivottable list of fileds, this add the data range to the data model.
But it looks like it is not possible to modifie this range source : new lines are not taken in account when updating Powerpivot table, no connection is defined, no link appears.
Does anyone knows how to chage this range source definition ? Thanks.
Chris
