CODEWITHSUNDEEP
excelpowerpivotvba
shashikiran
shashikiran

Reputation: 379

How to import data from a worksheet to the powerpivot from the same workbook

I wants to import data from a worksheet in a workbook "\foo.xlsx" to powerpivot in the same workbook "\foo.xlsx".

when i try to give the connection to the same workbook its gives the error:

The file you have chosen is in use. Please close the file before you import.

Is there any way to solve this problem??!!

Thanks

Upvotes: 0

Views: 2911

Answers (1)

Siraj Samsudeen
Siraj Samsudeen

Reputation: 1694

Please use Create linked table found in PowerPivot tab

Upvotes: 1

Related Questions