ORDER LINKED DATA

%3CLINGO-SUB%20id%3D%22lingo-sub-2334970%22%20slang%3D%22es-ES%22%3EORDER%20LINKED%20DATA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2334970%22%20slang%3D%22es-ES%22%3E%3CP%3EHi!%20I%20have%20an%20issue%20and%20I%20don't%20know%20how%20to%20solve%20it...%20I%20have%20an%20Excel%20document%20with%20a%20lot%20of%20data%20and%2010%20pages%20with%20more%20data.%20That%20data%20of%20the%20rest%20of%20the%20pages%20are%20linked%20to%20the%20data%20of%20the%20main%20page%2C%20so%20whenever%20I%20change%20the%20data%20in%20the%20main%20page%20it%20automatically%20changes%20on%20the%20other%20pages.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%2C%20so%20that%20data%20on%20the%20main%20page%20is%20ordered%20from%20the%20highest%20to%20lowest%2C%20but%20it's%20also%20very%20volatile%2C%20so%20I%20have%20to%20update%20it%20frequently%20and%20set%20again%20the%20order%20froma%20hightest%20to%20lowest.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20here%20it's%20when%20the%20problem%20comes...%20When%20I%20set%20again%20the%20new%20order%2C%20the%20linked%20data%20on%20the%20other%20pages%20lose%20their%20references%20and%20it%20keeps%20the%20position%20linked%20on%20the%20main%20page%20instead%20of%20following%20the%20data%20they%20were%20linked%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20it's%20hard%20to%20explain%2C%20but%20I%20hope%20you%20guys%20could%20understand%20me%2C%20because%20this%20is%20being%20very%20frustrating%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2334970%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335010%22%20slang%3D%22en-US%22%3ERe%3A%20ORDER%20LINKED%20DATA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335010%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047807%22%20target%3D%22_blank%22%3E%40JorgeAmor%3C%2FA%3E%26nbsp%3BMy%20first%20thought%20is%20why%20maintain%20separate%20sheets%3F%20Especially%20when%20the%20data%20changes%20as%20frequently%20as%20you%20describe.%20Better%20to%20keep%20one%20master%20list%20and%20extract%20from%20that%20whatever%20sub-set%20of%20data%20is%20needed%20when%20it%20is%20needed.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi! I have an issue and I dont know how to solve it... I have an Excel document with a lot of data and 10 pages with more data. That data of the rest of the pages are linked to the data of the main page, so whenever I change the data in the main page it automatically changes on the other pages. 

 

Well, so that data on the main page is ordered from the highest to lowest, but its also very volatile , so I have to update it frequently and set again the order froma hightest to lowest.

 

And here it's when the problem comes... When I set again the new order, the linked data on the other pages lose their references and it keeps the position linked on the main page instead of following the data they were linked to.

 

I know it's hard to explain, but I hope you guys could understand me, because this is being very frustrating for me.

 

Thank you!

1 Reply

@JorgeAmor My first thought is why maintain separate sheets? Especially when the data changes as frequently as you describe. Better to keep one master list and extract from that whatever sub-set of data is needed when it is needed.