Hi Serge,
Calc reads data only from the disk file when cells from different files
are linked. To update, save the changed data, then update using 'edit /
links / update.
tc
You appear not to be subscribed to the users' mailing list. You could miss many of
the replies to your post unless you do subscribe. Just send a blank message
addressed to <[EMAIL PROTECTED]> using the e-mail account through which you
want to receive it. You will receive a message asking you to confirm your
subscription by replying to it. See http://support.openoffice.org/index.html for more
options.
Subscribing is optional. Be aware that after subscribing, you may receive many
messages from the list. Be prepared to set up mail filters in your email client
in order to deal with them.
Serge De Troyer wrote:
Hello,
I am new with OpenOffice.org and I am testing it before leaving
eventually Excel.
The description:
In Excel, I have two files (spreadsheets). On the first one, some cells
are linked with result from the second one. When both files are opened,
as soon I change a value on the second spreadsheet, it is automatically
and immediately updated on the first spreadsheet.
I opened these files (.xls) with Calc, the cells are well linked and
calculated. But when I do a modification on the spreadsheet, it does
not change on the other. I put 'on' all the 'automatic calculate'
options I found, the automatic update does not work. The only way is to
close and save both files (in xls format for me), and if I reopened
one, the recalculation has been done, but never automatically.
Do you have an idea? Maybe it is not possible with Calc (but I would be
surprised). I certainly mis something.
Thank you for your idea
Best regards
Serge De Troyer
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
