hello all,
i have built me a sheet to download and evaluate the corona data from JHU,
- part of the file with the error - click to download / open -
one special thing goes wrong:
if i update the data in the sheet (by allowing ‘update’ after opening the file or with ‘edit - links to external files - update’) - note the red marked cells JF1:JG2 before, the references run ‘smoothly through’ to column JZ and more columns are downloaded for the sheet ‘cases_raw’, then the columns on the sheet ‘cases_sort’ change from JG on, and the formulas reference other cells, e.g. ‘cases_sort.JG1’ changes from ‘=cases_raw.JG1’ to ‘=cases_raw.JK1’, this is not intended and messes up all downstream work …
the two sheets are connected in two different ways, in row 1 and 2 of ‘cases_sort’ there are hard coded references to cells in the first two rows of ‘cases_raw’, below that there is an area which was filled with data by selecting ‘data_1’ on sheet cases_raw and then doing ‘data - sort - criteria col_b ascending, col_a ascending - options - copy output to cases_sort.A3’,
somehow the new download now has an effect on ‘cases_sort’ that i did not intend and do not understand … may this be due to some cryptic options? or is it a bug?
tia fah ‘thanks in advance’ - ‘for any help’
reg.
b.