Updating a pivot table with named table range
EXCEL - updating a pivot table when source data is in a named table range. A named range cannot be edited when it is used in a pivot table. The named range needs to be removed before doing an update.
EXCEL - updating a pivot table when source data is in a named table range. A named range cannot be edited when it is used in a pivot table. The named range needs to be removed before doing an update.