i have an excel with several sheets. (excel is located on onedrive)
sheet 1 contains a table which get populated with data coming from MS flow (add a row into table)
Sheet 2 references to cells on Sheet 1 --> e.g. =Sheet_1!$B$287
the problem is ,that whenever flow addsa row, the reference on sheet 2 get changed to =Sheet_1!$B$288
so how can i add flow data to an excelsheet and at the same time reference to these cells within other sheets ?