Excel 2013 - Pivot table data source won't refresh

[sparkanother]

Hi All,

I've encountered an annoying thing in Excel 2013.

I'm using pivot tables a lot, hence i'm creating template files, so all i need to do is to 'save as' the workbook, copy new data and refresh the pivot tables.
The annoying thing is that for whatever reason the data source points to the old workbook after the save as, so i have to amend it one by one.

Is there any workaround for this?

Thanks,
Adam

 

[Andrew Poulsom]

Welcome to MrExcel.

What is the Source of the pivot table in the template? I can't reproduce the behaviour you are describing if it's a Range, by the way.

 

[sparkanother]

Thanks for the quick reply.

When i'm creating the the pivot, i'm simply adding the range from another sheet.

 

[Andrew Poulsom]

What do you mean by "adding the range from another sheet"?

 

[sparkanother]

I'm selecting the data from another sheet as range. For example there is one sheet with the raw data, one with the pivot.

 

[Andrew Poulsom]

I can't reproduce the behaviour you are seeing. What does the Pivot Table Data Source box contain before and after the Save As?