I am learning how to import data in to Excel using a query and I have a couple of questions I would like some help with.
First, I have a query that brings about 6000 lines into Excel. I get the message “Selection is too large” during the query. All the data comes into the spreadsheet ok but the formulas to the right only extend down 1500 lines. Is there anyway round this ?
My second question is there a way to automate changing the selection criteria of the query. For example if the user of the spreadsheet enters a brand in a cell can this be automatically passed to the query as a selection criteria ?
First, I have a query that brings about 6000 lines into Excel. I get the message “Selection is too large” during the query. All the data comes into the spreadsheet ok but the formulas to the right only extend down 1500 lines. Is there anyway round this ?
My second question is there a way to automate changing the selection criteria of the query. For example if the user of the spreadsheet enters a brand in a cell can this be automatically passed to the query as a selection criteria ?