Share via

Set pivot table data source permanent

Anonymous
2016-10-31T13:13:17+00:00

Hi,

I have several pivot tables in a big Excel sheet (I may not share it). Everything works fine, until I change the name of the document.

The pivot tables then change their data source to the previous Excel file name.

How can I make sure this doesn't happen? So when I change the name of the file, the pivot tables just work as before and not referring to the older file?

Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-11-03T03:07:58+00:00

    It is good that your problem got resolved.

    But, without any knowledge gain !   We could not know/learn the reason behind the problem.

    Anyways, for now the problem is solved. Have a great day.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-11-02T15:27:10+00:00

    I reconnected the tables with their source and it seem to works. That is the best solution for now I think.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-11-02T14:47:38+00:00

    Oh!!

    Normally such a thing does not happen.

    Without having a thorough study of your file, it will be difficult to suggest anything and you cannot share your file.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-11-02T14:27:11+00:00

    Nope, There are slicers for the pivot tables, but that's it.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2016-11-01T06:59:07+00:00

    If the Pivot Table is created in the same SourceData xlsx file then, just renaming the Excel file should not disturb the Pivot Table.

    Are you missing some info which is not yet shared here ?

    Was this answer helpful?

    0 comments