On Thu, Jun 9, 2011 at 9:08 PM, Debora Wynne Rotisserie 360 < [email protected]> wrote:
> Hello > I've posted a problem on the forum, but nobody has managed to help me yet. > > I'm using Calc 3.3 on Windows 7 and am trying to link the value of a cell > in a spreadsheet to the value of a cell in a different spreadsheet. > > It doesn't work for some reason. > The easiest way I found was to: 1. copy the cells you want to link to; 2. switch to the spreadsheet you want to display the linked cells in; 3. right click on the destination cell and select "paste special" then 'link'; This will insert an array formula with the copied cells. Changes in the copied cells will be reflected in the pasted cells. There are other ways of achieving this linking which can also be found from googling... HTH, /paul > > Please help urgently. > -- > -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
