Add row into table - cell reference get moved after adding it

Super Contributor

following issue:


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 ?


thank you


0 Replies