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!
