Hi, I set up my organizational budget in a workbook with several tabs (sheets?) The main page brings in data from other pages, as you'd expect, with simple calculations.
In desktop Excel, if I add rows or columns or sort the second sheet, the master sheet still grabs the data from the right cell - if H12 suddenly becomes H15, the reference moves with it.
But in online excel, it doesn't work correctly - the data from H12 always goes into the calculated cell - the reference doesn't move with the data.
I know I didn't explain that clearly - hopefully someone gets what I mean and has the solution!
I must apologize as I am not too familiar with the intricacies of Excel Online. Perhaps the following will be of some use?