Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2016
    Posts
    2

    Unanswered: empty rows after refreshing query

    hi
    i have a query from oracel server dbase application that i created in excel via odbc
    the query contains 4 column from a to d
    i add vlooup functioc in column E .
    when i refresh the query after adding new records to the database
    the function is not auto fill
    for example if befor records adding i had 4 rows and i added 5 records
    i recived 9 rows but row 5-8 are empty in e column

    any one have idea why ?

    dacpa

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,088
    Provided Answers: 4
    You said you created a function in Excel's E column. In which rows? Apparently, rows 1 - 4.

    Did you spread the function through the rest of the rows?

Posting Permissions

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