SQL query not pulling through to excel table

Status
Not open for further replies.

KatP

New Member
Joined
Sep 2, 2020
Messages
15
Office Version
  1. 365
Platform
  1. Windows
Hello,

I have an SQL Query set up in my excel document and when I hit refresh it pulls through all the most recent data that has been inputted via a survey.

On a separate sheet I then have an excel table set up which I want to pull through the relevant data from the Query using simple formulas such as =TEXT('Raw Data'!E4,"MMM-YY"). I have dragged the formula down the entire table (And have expanded the table so there is numerous blank rows to allow new data to pull through upon refresh of the query)

When I refresh the query I would expect that the next row of data in the query would populate the next row in the table however this does not seem to happen for some reason. (I have set other reports up in the same way and it does work but for some reason it doesn't in this particular report)

I can drag the formula in the first cell of the table down again and it will pull through but I want it to do this without me having to manually update the table as I worry this will lead to error.

Can anyone think of any reasons why this does not work?

Many thanks for your help.

Kat
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
37,550
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Duplicate of this thread. Please don't post the same question more than once. Thanks. Thread closed.
 
Status
Not open for further replies.

Forum statistics

Threads
1,143,637
Messages
5,719,972
Members
422,253
Latest member
frankie2016tata

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top