Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.