• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table Data Source Issue‏

F

FadiK

New Member
Hi,

I created a table, and inserted a pivot table that uses this table as data source.
I closed the excel and renamed the file and then opened it again.
When trying to refresh my Pivot Table, I get the following Error:
"We couldn't get the data from 'Table1' in the workbook C: (old file name) Open this workbook in Excel and try again."
i.e. it is still looking for table using the old file name.

How to fix this?

Thanks.
 
Click on pivot. Go to ribbon tool and click change data source and remove path/file name from reference and just keep the table name.
 
No problem. Pivot has its limitations, but I love it for how it can slice and dice data on the fly. Happy pivoting ;)
 
You must log in or register to reply here.
Back
Top