• 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.

How to add a tab to PowerPivot Window?

G

GN0001

Member
Hello Team,
I need to copy some data to Power Pivot window. I open Power Pivot window and paste the data from Excel workbook. Now, I want to paste the second set of data to Power Pivot window; should I start a new Power Pivot window? Should I insert a new tab in Power Pivot window? (Please note, I am not trying to import data to Power Pivot window, because in that case, there is a chance a new tab would be automatically generated.
I have inserted a workbook for ease.
Regards,
GN0001
 

Attachments

  • example-data-upload.xlsx
    767 KB · Views: 3
Hi,

Is selecting any cell of table and selecting Create Linked Table option from Power Pivot Tab is working for you? If you repeat the step for say 3 table you will have 3 linked table inside Power pivot window. See below image.

Capture.JPG

Or see the file.

Note I had created this with Excel 2010, if you are using 2013 than the model may not work.

Write back if you need anything more and I did not understood your requirement.



Regards,
 

Attachments

  • example-data-upload.zip
    319.8 KB · Views: 2
Hello Somendra,
Thank you so very much for your answer. :)

I don't want to bring the data into Power Pivot window with linking to the original data. As I said on my first post:
(Please note, I am not trying to import data to Power Pivot window, because in that case, there is a chance a new tab would be automatically generated.)

I know the tabs are generated automatically when we do link/ connection to the data ( I was guessing and your posted file verified the case); but if we have a specific case that we need to copy and paste the data, then what would we do for second and third set of data?

I appreciate your answer.
GN0001
 
Somendra Misra said:
Hi,

Is selecting any cell of table and selecting Create Linked Table option from Power Pivot Tab is working for you? If you repeat the step for say 3 table you will have 3 linked table inside Power pivot window. See below image.

View attachment 12733

Or see the file.

Note I had created this with Excel 2010, if you are using 2013 than the model may not work.

Write back if you need anything more and I did not understood your requirement.



Regards,
Click to expand...
 
Now I want to import the data into Excel from an Excel workbook, I can't.
The connection is not set.
Thanks.
GN0001
 
You must log in or register to reply here.
Back
Top