Sharepoint Excel: Linked cell value changes when I insert a column/row in the source workbook

Occasional Visitor

Hi there,

I am using excel in the online sharepoint platform.  For example, in workbook A, I have linked cells to to workbook B.  If I delete a row/column in workbook B, the value in the cell in workbook A will change to the new value in the linked cell.  How can I make the link in workbook A move with cell in workbook B (note - this is only an issue I have noticed in Sharepoint excel. When using the Excel application itself, it works properly).  Is there an option for this I am missing somewhere?  

 

Thanks in advance for your help!

0 Replies