Excel Query to another doc

[bb43442]

Hi all

I have a query in an excel doc named "Document 1.xlsx"

This refreshes daily.

This is too slow to load into my sheet on sharepoint so I am referencing it by ='[Document 1.xlsx]Sheet 1'!$B2 in my "Document 2.xlsx"

However as soon as data is added in Document 1, Column B (e.g. B3)

It doesn't refresh in my new document "Document 2.xlsx", I have to refresh the column by re-entering ='[Document 1.xlsx]Sheet 1'!$B2 down the column.

There is no lookup. as this is the first field the rest of my lookup is based on.

Is there a way to load this information without loading the query direcly?

Thanks heaps