Excel Power Query Connector to document

Want to connect through excel power query  to excel document directly rather than having to save it locally and then connect to it.