Excel Query Problems, Not Getting All Data
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Excel Query Problems, Not Getting All Data

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a macro getting info from another workbook from columns A thru D. On some sheets the query will return all of the data. On others it will not return data from column B. I have checked the source workbook that is being queried and it does have data that it is not getting.

    Anyone have any ideas on how to fix this?

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    The column the data will not come from contains Room numbers. I have found that it will return anything that looks like text. If the data is a number it will not return it. Example: it will return 33/16 but won't return 100.
    I have formatted the source column as general and have tried text. Neither work.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com