Results 1 to 9 of 9

Thread: How to set data source for pivot table permenant even if file name or path changed in

  1. #1

    How to set data source for pivot table permenant even if file name or path changed in



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    The pivot table I am making contains data source that is already existing in the same file.
    As soon as file name changed or file path location changed , the pivot table no longer working and as soon as I do any refresh in the pivot able it is reporting a error that data source does not exist.
    I've tried several ways as set data source as a table but no way.
    This is the file:-
    https://www.dropbox.com/s/c4lfagmxza...rformance.xlsx
    So how can I make or set data source to be permanent so in case file renamed or copied from place to another ... pivot table still works.
    Thanks

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,479
    Articles
    0
    Excel Version
    365
    In the Change PivotTable Data Source dialogue box you currently have:
    '\Users\MohamedGad\Dropbox\ahmed-survey\New folder\employee_performance.xlsx'!Table1
    change it to:
    Table1

  3. #3
    Quote Originally Posted by p45cal View Post
    In the Change PivotTable Data Source dialogue box you currently have:
    '\Users\MohamedGad\Dropbox\ahmed-survey\New folder\employee_performance.xlsx'!Table1
    change it to:
    Table1
    each time I change it to Table1, as soon as I move it to another place it is break once again.

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,479
    Articles
    0
    Excel Version
    365
    I've just tried to replicate what's happening with you and I can't.
    You are saving the file after you've reduced the source to just Table1 but before you try to copy/move it?

  5. #5
    Quote Originally Posted by p45cal View Post
    I've just tried to replicate what's happening with you and I can't.
    You are saving the file after you've reduced the source to just Table1 but before you try to copy/move it?
    what do you mean?

  6. #6
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,479
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by MGadAllah View Post
    what do you mean?
    Well,
    Quote Originally Posted by p45cal View Post
    I've just tried to replicate what's happening with you and I can't.
    This means that I've taken your file, saved it on my drive, changed the source data reference to Table1, saved the file, closed it. Then
    1. I've takes a copy of the file and saved it somewhere else, and
    2. I've also moved the file somewhere else
    In both cases the data source reference remained Table1, which is the behaviour I expected.
    With you, you say it does something else; I wasn't able to replicate the behaviour you get over here (replicate = get the same behaviour here).





    Quote Originally Posted by p45cal View Post
    You are saving the file after you've reduced the source to just Table1 but before you try to copy/move it?
    I'm checking here that you have saved the file after you've shortened the source data reference to Table1, and before you try moving it around or copying it somewhere else. If you don't save the file you won't change anything.

    Now do you understand what I mean?

  7. #7
    Thanks a lot and your time

  8. #8
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,479
    Articles
    0
    Excel Version
    365
    So, is your problem solved?

  9. #9
    Quote Originally Posted by p45cal View Post
    So, is your problem solved?
    Yes I rebuild the whole file and did not copied anything from outside the file and set the data source as a table and it is working now.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •