Hi :) Congrats on fixing the problem :) Thanks for the flowers but it was Steve Edmonds that gave the answer that helped you there so i'll pass the flowers on to him :) In Nabble it is possible to check a star by a good answer so i marked Steve's post like that. One of the dangers of snipping is that personal biases or misunderstandings can get exaggerated but on the plus side that then often leads to people correcting those misunderstandings. Often lots of people are quick to criticise even if they weren't willing to make their own suggestion to try to help. Naming cells seems to deal with the problem for me but i think i must have missed the point. I have dragged named cells all over the place and moved them to other worksheets, over-written the values in them and moved the cell containing the formula similarly and the value produced is calculated from the correct cells where-ever they are. I guess i missed the first post in the thread and it got snipped from all the replies. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Calc-cut-paste-removes-and-renames-protected-field-references-is-this-a-bug-tp3417657p3423459.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