+ Reply to Thread
Results 1 to 2 of 2

QUERY reaching its limit

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Sydney
    MS-Off Ver
    MS Office 365/16
    Posts
    282

    QUERY reaching its limit

    Hi all,

    I have a Query function that is going weird
    =QUERY(FormResponses01!A:RW,"select C, E,I,U,V,X,Y,Z,AB,AC,AD,AF,AG,AH,AJ,AK,AL,AN,AO,AP,AR,AS,AT,AV,AW,AX,AZ,BA,BB,BD,BE,BF,BH,BI,BJ,BL,BM,BN,BP,BQ,BR,BT,BU,BV,BX,`BY`,BZ,CB,CN,CR,CQ,CY,DC,DB,DJ,DN,DM,DU,DY,DX,EF,EJ,EI,EQ,EU,ET,FB,FF,FE,FM,FQ,FP,FX,GB,GA,GI,GM,GL,GT,GX,GW,HE,HI,HH,HP,HT,HS,IA,IE,ID,IX,IY,JA,JB,JC,JE,JF,JG,JI,JJ,JK,JM,JN,JO,JQ,JR,JS,JU,JV,JW,JY,JZ,KA,KC,KD,KE,KG,KH,KI,KK,KL,KM,KO,KP,KQ,KS,KT,KU,KW,KY,KZ,LA,LC,LD,LE,LN,LR,LQ,LY,MC,MB,MJ,MN,MM,MU,MY,MX,NF,NJ,NI,NQ,NU,NT,OB,OF,OE,OM,OQ,OP,OX,PA,OZ,PI,PM,PL,PT,PX,PW,QE,QI,QH,QP,QT,QS,RA,RE,RD where C = date '2019-11-02' order by E ASC")
    I've seem to discover that any columns pass JO causes the query to go weird. Is there a limit?

    Here is the link to view what I have: https://docs.google.com/spreadsheets...it?usp=sharing

    You will notice in Sheet "Data_2019_Term04_Week03", Row 1 - the subheadings are all combining.

    Thanks,

  2. #2
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Sydney
    MS-Off Ver
    MS Office 365/16
    Posts
    282

    Re: QUERY reaching its limit

    well that is weird...seems to be working now. Not sure how it fixed itself. I will keep this as unsolved for now in case it pops up again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Limit Simultaneous Web Query Connections
    By seethesun in forum Excel General
    Replies: 16
    Last Post: 04-08-2024, 10:48 AM
  2. [SOLVED] Summing Until Reaching a Certain Value
    By Jaredm577 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-02-2019, 07:19 PM
  3. Google maps api over query limit
    By ChipsSlave in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2016, 01:52 PM
  4. Look UP formula Query -to add an upper limit
    By Excel Dumbo in forum Excel General
    Replies: 3
    Last Post: 09-26-2014, 12:58 AM
  5. Pivot Tables reaching record limit.
    By lifeseeker1019 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-14-2013, 06:32 AM
  6. UsedRange.Rows.Count Reaching Limit at r257
    By pisteuo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-05-2012, 10:56 AM
  7. Size Limit for ADO query?
    By cesw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1