This happens because of the strange way Calc works - http://www.openoffice.org/issues/show_bug.cgi?id=74243. You need to use DDE links (Paste Special - Link).
> -----Original Message----- > From: Sam Lim [mailto:[EMAIL PROTECTED] > Sent: Monday, May 21, 2007 11:55 AM > To: [email protected] > Subject: [users] Links do not get update on the fly > > Hi everyone, > > > > I'm currently facing this trouble of using Openoffice.org's Calc. > > > > Cells with links to another cells in another sheet residing > in another file does not get updated on the fly. > > > > Take for an example, if I'd just made a new change to cell A5 > on Sheet1 of the file named Test1.ods sitting in C:\ to > contain the number 100 > > And the make cell A5 on Sheet1 of the file named Test2.ods > sitting in C:\ to point to result 100, it returns me with a 0. > > > > Is there a way to have the cells update itselfs on the fly > without going to Edit - Links - Update? > > > > Best regards, > > Sam Lim > > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.467 / Virus Database: 269.7.6/813 - Release > Date: 5/20/2007 > 7:54 AM > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
