Cell references get mixed up when I sort the data

%3CLINGO-SUB%20id%3D%22lingo-sub-1521769%22%20slang%3D%22en-US%22%3ECell%20references%20get%20mixed%20up%20when%20I%20sort%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521769%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20set%20up%20my%20organizational%20budget%20in%20a%20workbook%20with%20several%20tabs%20(sheets%3F)%26nbsp%3B%20The%20main%20page%20brings%20in%20data%20from%20other%20pages%2C%20as%20you'd%20expect%2C%20with%20simple%20calculations.%3C%2FP%3E%3CP%3EIn%20desktop%20Excel%2C%20if%20I%20add%20rows%20or%20columns%20or%20sort%20the%20second%20sheet%2C%20the%20master%20sheet%20still%20grabs%20the%20data%20from%20the%20right%20cell%20-%20if%20H12%20suddenly%20becomes%20H15%2C%20the%20reference%20moves%20with%20it.%3C%2FP%3E%3CP%3EBut%20in%20online%20excel%2C%20it%20doesn't%20work%20correctly%20-%20the%20data%20from%20H12%20always%20goes%20into%20the%20calculated%20cell%20-%20the%20reference%20doesn't%20move%20with%20the%20data.%3C%2FP%3E%3CP%3EI%20know%20I%20didn't%20explain%20that%20clearly%20-%20hopefully%20someone%20gets%20what%20I%20mean%20and%20has%20the%20solution!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1521769%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521822%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20references%20get%20mixed%20up%20when%20I%20sort%20the%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521822%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F728487%22%20target%3D%22_blank%22%3E%40Jenny_Hansell%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20must%20apologize%20as%20I%20am%20not%20too%20familiar%20with%20the%20intricacies%20of%20Excel%20Online.%20Perhaps%20the%20following%20will%20be%20of%20some%20use%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fkeeping-cell-references-after-sorting%2Fa2cc60ce-c97a-4149-94fc-a87ce47ce0bd%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fkeeping-cell-references-after-sorting%2Fa2cc60ce-c97a-4149-94fc-a87ce47ce0bd%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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!

1 Reply

Hello @Jenny_Hansell,

 

I must apologize as I am not too familiar with the intricacies of Excel Online. Perhaps the following will be of some use?

 

https://answers.microsoft.com/en-us/msoffice/forum/all/keeping-cell-references-after-sorting/a2cc60c...