I'm trying to update a pivot table with more data. I've done this successfully for all the other tables in this particular workbook. However, there's one that won't update. I set the new range in the Change Data Source, but the table doesn't reflect the new data. Hitting Refresh doesn't do anything. I've checked and double-checked that the new range is correct, and when I go the Change Data Source again, the correct range is shown to be there. However, my table refuses to update.

Any help?

Thanks.