Create a New Query from an open workbook

N

Nothnless

Board Regular
Joined
Apr 28, 2016
Messages
142
In this case I have my Get and Transform query steps setup up but I need the data source to be from a different excel workbook I opened from an email. In other words the source data might not even be saved locally, it’s just open.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

D
  • Question
Power Query refresh taking HOURS after adding custom column
Replies
3
Views
440
Matt Allington
M
M
  • Question
Can you change a source in power query for excel?
Replies
1
Views
108
alansidman
A
M
  • Question
Database Username / Pass for Power Query Connection not saving in Excel workbook
Replies
1
Views
472
ExcelToDAX
E
T
  • Solved
Data query connection
Replies
4
Views
372
tcourter
T
L
  • Question
Excel Power Query Refresh Does Not Update
Replies
2
Views
610
legalhustler
L

Forum statistics

Threads
1,215,800
Messages
6,126,981
Members
449,351
Latest member
Sylvine

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