For those of you working with an organization that uses smartsheet.com, which is a basically a big shared spreadsheet for project management purpose, check out a query linked below which pulls data from a desired sheet into Excel.
https://www.reddit.com/r/excel/comments/97tsbs/how_to_connecting_excel_power_query_to/
