At 18:19 14/02/2016 -0700, luquino wrote:
I have a calc book in which some cells make reference to the contents of some cells in another book. I could easily vinculate the cells to the other book, I just wrote "=" in the destination cell and then I made a simple click in the origin cell in the other book. Amazing. But now I have a little problem, if the origin cell change, the destination cell doesn't, I have to close and reopen the book. What I can do to see the changes in the dest cell?
I'm never sure under exactly what circumstances different techniques work, but you can try these:
o You probably need to save the source document after any changes have been made (but not necessarily to close it).
o There is a setting at Tools | Cell Content > | AutoCalculate which ought to achieve what you need (but I'm not sure always does).
o You can force a recalculation at Tools | Cell Content > | Recalculate or by pressing F9.
o Sometimes you will need to use Recalculate Hard, which is available at Ctrl+Shift+F9.
o If all else fails, there is a slightly simpler way than closing and reopening the target document: first save any changes if necessary, and then use File | Reload to stimulate the prompt about updating links.
I trust this helps. Brian Barker -- To unsubscribe e-mail to: [email protected] 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
