When I go to sort data from a column that contains data from other spreadsheets, it messes up my equations and called cells. How do I get these to stay in place while sorting? I'll use Tunisia as an example... before the sort its cell is defined as ='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIBAWC.B24 and then after I sort it its all of a sudden: ='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIBAWC.B#REF! (its trying to call a cell that is not there in another spreadsheet). Why is it changing my formula when I was it to be 2010.ods'#$FIBAWC.B24? Another example is Italy, I want it and have it to be ='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIFAWC.B26 and then after I sort it goes to ='file:///C:/Users/ajax/Desktop/teamrankings/2010.ods'#$FIFAWC.B19 http://nabble.documentfoundation.org/file/n3375803/before.png http://nabble.documentfoundation.org/file/n3375803/after.png -- View this message in context: http://nabble.documentfoundation.org/Sorting-Called-Data-tp3375803p3375803.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted