You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
when I use the following in an excel cell, the task pane just says "1 of 1 rows imported. Saving..." and never actually brings back the query result.
I get a momentary #BUSY! message in the cell, then an "Import started at..." message in the cell. That's all.
I'm just trying to insert the Summary field value into the excel cell, not bring back a table or a property for multiple issues.
Edit: I tried this a different way, using a blank workbook and the following was the result, using 4 cells -- the cell I used the formula in, plus the 3 cells below it. This is not what is expected. Why would the 1st 3 rows come back from this usage? It seems poorly implemented if this is what was expected.
|Import started at November 14, 2019 2:25 PM by Rob Wickham|
|1 rows imported in 2 seconds|
|Risk management and customer requirements embedded within each process definition|
It's definitely been implemented with the expectation of returning a table of results, rather than a single field for a single entry. I see two ways to get round this...