Question description:
This user has given permission to use the problem statement for this
blog.
I would like to know if it i possible for me to create a power query that will update automatically as the connections i have inputted into the query are updated with new data.
Solved by G. J. in 15 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
13/04/2018 - 03:56
Hi
Excelchat Expert
13/04/2018 - 03:56
Welcome to Got it Pro
User
13/04/2018 - 03:56
hi
User
13/04/2018 - 03:57
ty
Excelchat Expert
13/04/2018 - 03:57
When the connection that you input changes the power query will update automatically
User
13/04/2018 - 03:58
thank you
Excelchat Expert
13/04/2018 - 03:58
You are Welcome
Excelchat Expert
13/04/2018 - 03:58
Please let me know if you need anything else
Excelchat Expert
13/04/2018 - 03:59
I would be happy to help you out
Excelchat Expert
13/04/2018 - 03:59
Also looking for good rating and reviews from you
Excelchat Expert
13/04/2018 - 03:59
It really helps
User
13/04/2018 - 03:59
you got it!
Excelchat Expert
13/04/2018 - 04:00
Thanks
Excelchat Expert
13/04/2018 - 04:00
You will get an option to rate when you end the session
User
13/04/2018 - 04:00
would you be able to tell me step by step the best way to use the get & transform feature in excel 2016 to take information from other rep exel sheets and combine them all into a master
Excelchat Expert
13/04/2018 - 04:02
To use Get & Transform in Excel 2016, you create a query in your workbook. A query enables you to connect to, preview, and transform data from a wide variety of available data sources. You can then load that transformed data into a table, or into the built-in Data Model in Excel 2016, and even refresh that data later on. You can also edit the query whenever you need to, and share your query, too.
Excelchat Expert
13/04/2018 - 04:03
To create a query in Excel 2016, use the Data tab in the ribbon, then select the New Query button from the Get & Transform ribbon group.
Excelchat Expert
13/04/2018 - 04:03
Related Get & Transform features are also available from the Get & Transform ribbon group in the Data ribbon.
Excelchat Expert
13/04/2018 - 04:04
Looking at those steps in order, they often occur like this:
Connect – make connections to data sitting in the cloud, in a service, or locally
Transform – shape the data to meet your needs; the original source remains unchanged
Combine – create a data model from multiple data sources, and get a unique view into the data
Share – once your query is complete you can save it, share it, or use it for reports
Excelchat Expert
13/04/2018 - 04:04
Have look at this for step by step process
Excelchat Expert
13/04/2018 - 04:04
https://support.office.com/en-us/article/getting-started-with-get-transform-in-excel-2016-a8310388-2a12-438c-9d29-c6d29cb8df6a?ui=en-US&rs=en-US&ad=US
Excelchat Expert
13/04/2018 - 04:05
Let me know if this helps you out
User
13/04/2018 - 04:06
ok thank you so mcuh
Excelchat Expert
13/04/2018 - 04:06
Does this help?
Excelchat Expert
13/04/2018 - 04:06
Looking forward to good rating and reviews from you
User
13/04/2018 - 04:07
i think it will, i havent had a chance to test it out yet
Excelchat Expert
13/04/2018 - 04:07
Ok
Excelchat Expert
13/04/2018 - 04:07
It will definitely help you out
Excelchat Expert
13/04/2018 - 04:08
Have a great day
User
13/04/2018 - 04:08
you too!
Excelchat Expert
13/04/2018 - 04:08
Thanks
Excelchat Expert
13/04/2018 - 04:08
Do provide good rating when you end the session
Excelchat Expert
13/04/2018 - 04:08
it really helps
User
13/04/2018 - 04:08
I will
Excelchat Expert
13/04/2018 - 04:09
Thanks
Excelchat Expert
13/04/2018 - 04:11
You can end the session if you want
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.