Excel 2013 Pivot Data Range formula reference problem

  • Thread starter Karthik Raghothaman
  • Start date
K

Karthik Raghothaman

Hello,

I recently got upgraded to office 2013 and its giving me hard time with Pivot tables. When i create a pivot table with the data within the workbook and save the file, the pivot works fine as long as the file is in the same location/network path. If the file is moved to different location/network path the pivot data range formula still refers to the old location/network path and when the pivot refresh is done it give me an error message saying thedata reference is not valid.

Has anyone faced this issue in office 2013 and is there any solution to fixthis problem?

Any help on this will be greatly appreciated.

Regards,

Karthik R
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013 vlookup to different workbooks not working 3
SUM & OFFSET & PIVOT TABLE?? 0
Word 2013 DDE merge to Excel file 0
Word 2013 merge Excel, DDE conncetion path problem 0
making an excel table visible for external data on pivot table 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Get Pivot data not reading some cells 0
not your typical Pivot Table Named Range question 7

Top