| Author |
 Topic  |
|
|
tys8888
1 Posts |
 Posted - 06/04/2024 : 07:45:29 AM
|
Origin Ver. and Service Release (Select Help-->About Origin):
OriginPro 2019 (64-bit)
9.6.0.172 (Academic)
Operating System: Win 11
Hello,
Currently I'm making a workbook template, which..
1) "Sheet 41" has raw data, consisting of 4040 rows of data in Column A.
2) In "Sheet 1", Column A's F(x), I typed "Sheet41!A[1:101]", to refer "Sheet 41"'s data ranging from 1st row to 101st row.
3) In the same way, "Sheet 2", in F(x), "Sheet41!A[102:202] is there.
4) throughout "Sheet 3" ~ "Sheet 40", and Column B~E, it goes the same.
But I found that whenever I change raw data in "Sheet 41", sheets 1~40 does not follow the data of corresponding row. Rather, Those are following only 1~101st row. When I re-type f(x) of each sheet, it shows right value. But I can't re-type them all since I got tons of raw data.
Could you tell me how to resolve this?
This is the file that is in trouble. Sharing via my google drive:
https://drive.google.com/file/d/18Qb2NhmeqgQUDLuHINGlWcncZUnfe3oQ/view?usp=sharing
Thanks,
Sungmin |
Edited by - tys8888 on 06/04/2024 07:47:07 AM |
|
| |
Topic |
|
|
|
Referring wrong dataset (regarding F(x))
