Change chosen partitions in an existing workbook?

Follow

Steve Bernstein

• August 07, 2017 17:18

I have a workbook I started by choosing a subset of available partitions from a Datalink.  I'd like to edit the partitions I originally chose.  In particular, adding more partitions.  I don't see how to do that, other than starting over again.

0

• 

  Alan

  • August 07, 2017 17:36

  Hi Steve,

  Have you tried using the Add Data button and then re-selecting your data link?  This is how I would expect to be able to add additional data from other partitions even if you're using the same original source.

   

  Alan

  0

  Comment actions Permalink
• 

  Steve Bernstein

  • August 07, 2017 17:48

  Hi Alan,

  Thanks--

  That approach seems to add the data in a new sheet tab.  I need to expand the data in the original tab, if possible.  Otherwise, I guess I could try to replace the original tab with the newly added tab and hope that it's not too much work to "fool" my other, dependent sheets to use the new tab...?  Was hoping for something a little more straight forward...

  0

  Comment actions Permalink
• 

  Steve Bernstein

  • August 07, 2017 17:51

  Actually, I think it's "Exchange Data" I want, not Add Data--trying it now.

  0

  Comment actions Permalink
• 

  Alan

  • August 07, 2017 17:52

  Steve,

  I see, I'm pretty sure you can get the desired behavior using the Exchange Data button to the right of the Add Data button.  

  Otherwise you'll need to create a union sheet of the two sources, then change the sheet name in the formulas on your calculated sheet to match the new union sheet.

  Alan

  0

  Comment actions Permalink

Please sign in to leave a comment.