Results 1 to 10 of 10

Thread: Change data source

  1. #1

    Change data source



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

    I created a pivot table by using source of table/range.
    It seems it cannot be changed to external source once the source is chosen at the first time. Am I right?
    Click image for larger version. 

Name:	source.png 
Views:	26 
Size:	30.3 KB 
ID:	921

  2. #2
    That works fine. Did you try it?

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,274
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Actually, Bob, it doesn't look like you can...

    If you created a local pivottable, you can change the source to another local table. If you created an external source, you can update the external source. But if you create local, you can't go to external or vice versa.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  4. #4
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,467
    Articles
    0
    Excel Version
    2010 on Xubuntu

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,274
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Whoiswct,

    I know that they have linked you to my article on cross posting here. I would suggest that, if you haven't read it already, that it may be a good idea to do so now. That link, for your reference, is http://www.excelguru.ca/forums/faq.php?faq=crossposting
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  6. #6
    Hi Ken,

    Noted with thanks.

    But it is quit funny for the rule of cross post. It seems it is assumed the forum users are common in both forum.

    Sent from my phone using Tapatalk

  7. #7
    Quote Originally Posted by whoiswct View Post
    But it is quit funny for the rule of cross post. It seems it is assumed the forum users are common in both forum.
    Most of us are active in many forums, but even if we aren't, if people if both forums are working on your problem they could be wasting time, and our time is just as precious as yours.

  8. #8
    Quote Originally Posted by Bob Phillips View Post
    Most of us are active in many forums, but even if we aren't, if people if both forums are working on your problem they could be wasting time, and our time is just as precious as yours.
    Hi Bob, sorry for the off topic discussion but I just want to share my point of view.

    I am not sure if both forum is alliance. If yes, why don't close one of them and thus we can concentrate on one forum only. If not, it may become a unfair rule for the forum owners.

    Imaging there are two TV channels in your city and it is advised the ad sponsor should choose either one of the channel only for their ads promotion. What will be the result? Think about that.

    Sent from my phone using Tapatalk

  9. #9
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,274
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    whoiswct,

    If you were paying for every post you made on every forum, then by all means, post away to your hearts content trying to get the best answer. Experts-Exchange has made their whole business model off of that, which they are welcome to, as far as I'm concerned.

    While I suppose you could argue that we're in competition with each other, www.excelforum.com, www.vbaexpress.com, www.thecodecage.com, www.ozgrid.com, www.mrexcel.com (to name a few) share an identical user-pay model. Each of these forums is free to use. Absolutely no cost to you at all. (We try to value add with other products to pay the hosting costs, thereby keeping the forums free.) No, we're not in an alliance, per se, but we certainly do support each other, as we're all ultimately trying to do the same thing: help people. In fact, most of these free forums share the same overall attitude.... With over 300 million users of Microsoft Office software, there is more than enough room on the net for a couple of dozen different forums. Each has it's own culture and flavour, and that allows users to find a place that they like best and fit in.

    What makes our model work is the reliance of other experts who also just want to see users get help. And that, right there, is the crux of the cross-posting issue. The reality is that those experts are actually few and far between, and they VOLUNTEER their time.

    From my own perspective, I work full time, run my own business and volunteer in my community as well. My time is very limited, and my goal here is to help users. I don't charge them for this privilege, and I have a few reasons of my own for that. You can call me foolish if you will, but helping people is a passion of mine. But the point is this. If you've posted at my forum and another, and we don't know, then you've got two separate people working on answers. I've had SEVERAL instance where I've spent HOURS working on a solution for someone, only to find out that they had it solved the day before on another forum. And those hours that I wasted on a solution for someone who didn't need it were then lost to me. End result is that someone else went without an answer to their question.

    It's because of that sting that I wrote the cross-posting policy that is on this site. And if you think that it puts any forum at a disadvantage, then consider this... I have thousands of incomming links to that page from forums. The other site owner's aren't threatened by it at all, they embrace it.

    Honestly, I think you've truly missed the point of the article. No one is saying pick one forum over another. What we're saying is:

    1. Give the forum you posted at a reasonable chance to answer and then,
    2. If you do cross post then post links in both directions so that we can see it.


    It's respectful to the owners and it's respectful of the experts (many of whom do transcend boards).

    Whoiswct, you're welcome to post here, and I'll do what I can to help you. But I really don't think it's unfair to ask for the courtesy of knowing who else is working on something at the same time.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  10. #10
    Hi Ken, Understood your concerns. That's fine.

Posting Permissions

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