All Forums  Origin Forum  Origin Forum  Referring wrong dataset (regarding F(x))

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by tys8888[/i] [br]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 [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.