Share via

Excel doesn't evaluate function after getting data from SQL db

Anonymous
2022-11-19T18:23:23+00:00

I am getting data from SQL and loading it into a worksheet.  Some of the cells have text that contain a function call, like "=HYPERLINK("bbg://securities/A&ENET%205.5%2012|01|25%20Corp/DES","D")"

All it's trying to do is show the link as one character.  It should evaluate to "D".

However, after getting data, the cell shows the the entire text above.  To get the "D" to display, I have to edit each cell and hit ENTER.  I searched the web for a solution, but could not find one that worked.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-11-23T00:39:45+00:00

    sort by ticker and issuer

    how about change

    order by ticker,issuer

    in sql satement rather than import then sort in Excel

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-11-22T22:51:58+00:00

    Query - PRISM_Master_View

    can you modify this avoiding formula.

    then try ado range.copyfromrecordset to retreive data.

    if delete this loop,will it run obviously quickly?

    For Each c In Selection

    c.FormulaR1C1 = c.Value

    Next c

    Was this answer helpful?

    0 comments