Switch To option disabled

K

kryptonian

Board Regular
Joined
Oct 6, 2006
Messages
104
Hi. I have several Excel files with the same structure that I want to combine in PowerPivot for Excel 2010. I already imported 1 file in PowerPivot and want to add the other files via Query Editor but the Switch To option is disabled. Sometimes it works but most of the time doesn't. Am I missing a step?
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

J
  • Question Question
Using Slicer (or other Tool) to Add/Remove Fields from Rows of Pivot after Powerpivot (No-VBA)
Replies
1
Views
291
Matt Allington
M
T
  • Question Question
Power Query - Help combining workbooks with some shared column names but also different columns names
Replies
3
Views
197
johnny51981
J
E
  • Solved
Is there a resolution or alternative when experiencing Power Pivot memory errors?
2
Replies
12
Views
695
ez08mba
E
Guzzlr
  • Question Question
Power Query Question
Replies
1
Views
173
RoryA
RoryA
E
  • Question Question
Accounts Receivable ledger via Power Query
Replies
1
Views
407
johnny51981
J

Forum statistics

Threads
1,223,248
Messages
6,171,021
Members
452,374
Latest member
keccles

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top