M
Mikkel Randorf Hegnhøj
Hi there!
I've experienced the following issue:
1. I create an query to get data from en external datasource (Oracle database)
2. The data is retrieved and put dierctly in to a table
3. On a new worksheet I create a formula to take the data from the different
columns in the table and concatenate them in to one string (e.g. =Sheet1!A2 &
" - " & Sheet1!B2 & " - " & Sheet1!C2)
4. This formular is copied to the number of rows on this new worksheet, that
corresponds to the number of rows in the table. In this example the last row
could be row 22 (=Sheet1!A23 & " - " & Sheet1!B23 & " - " & Sheet1!C23)
5. Now when I update the data in the table (= refresh the data) and more
data comes in from the data source (The 22 rows becomes 25 rows), the last
row on the second worksheet cahnges it formula to the last row ((=Sheet1!A26
& " - " & Sheet1!B26 & " - " & Sheet1!C26).
6. I would then copy the formula to the next 3 rows to get the new data in
the second worksheet - and that is no problem, only you haev to take in to
account that the formula in the last row (21) have changed.
I've tested this in two different workbooks, with two different queries and
formulas to two different databases (both Oracle though).
I've also tested this with a table where the data does not come from an
external source, then there is no problem.
I hope I've made the description of this issue clear - otherwise, please ask
and I'll try to clearify :.-)
Best Regards
Mikkel Randorff Hegnhøj
I've experienced the following issue:
1. I create an query to get data from en external datasource (Oracle database)
2. The data is retrieved and put dierctly in to a table
3. On a new worksheet I create a formula to take the data from the different
columns in the table and concatenate them in to one string (e.g. =Sheet1!A2 &
" - " & Sheet1!B2 & " - " & Sheet1!C2)
4. This formular is copied to the number of rows on this new worksheet, that
corresponds to the number of rows in the table. In this example the last row
could be row 22 (=Sheet1!A23 & " - " & Sheet1!B23 & " - " & Sheet1!C23)
5. Now when I update the data in the table (= refresh the data) and more
data comes in from the data source (The 22 rows becomes 25 rows), the last
row on the second worksheet cahnges it formula to the last row ((=Sheet1!A26
& " - " & Sheet1!B26 & " - " & Sheet1!C26).
6. I would then copy the formula to the next 3 rows to get the new data in
the second worksheet - and that is no problem, only you haev to take in to
account that the formula in the last row (21) have changed.
I've tested this in two different workbooks, with two different queries and
formulas to two different databases (both Oracle though).
I've also tested this with a table where the data does not come from an
external source, then there is no problem.
I hope I've made the description of this issue clear - otherwise, please ask
and I'll try to clearify :.-)
Best Regards
Mikkel Randorff Hegnhøj