That will not work, but only for 1 value in the origin cell on sheet 1. If the origin cell on sheet 1 undergoes a value change, that change will not carry over to the target cell on sheet 2.
So if sheet 1's origin cell is dynamic, and its value is changed, by, say, adding another number in to the origin cell [remember, the OP was using the formula =SUM(:) in the origin cell on sheet 1] one needs o utilize the LINK function in the "Paste Special"pop up / drop down screen. On Fri, Jun 3, 2016 at 9:13 AM, Steve Ahlers <sahlers...@yahoo.com.invalid> wrote: > > Even easier, type "=" in the formula bar for destination cell, then > navigate to the original cell, click on it and hit "Enter" ( or "Return") > > Steve > Sent from my iPad > > On Jun 3, 2016, at 7:21 AM, Jim McLaughlin <jjim.mclaugh...@gmail.com> > wrote: > > > try this: > > > > highlight cell to be copied> click edit >click copy;>navigate to sheet > > where cell is to be pasted> navigate to cell on second sheet where > original > > cell is to be pasted >highlight destination location > edit > click > "paste > > special" > on grey pop up screen click "link" > > > > On Fri, Jun 3, 2016 at 7:07 AM, Clay McCall <mccall.c...@gmail.com> > wrote: > > > >> I am trying to carry over a =sum() value from a cell in one spreadsheet > to > >> another cell in another sheet in the same spreadsheet file. The > >> instructions in the help section “Referencing a Cell in the Same > Document” > >> says that the formula is =sheet2.A1, I have discovered that if you > rename > >> the sheets then this does not work. Why can I not reference a sheet by > >> another name? > >> > >> Thanks for any assist, > >> > >> R/ > >> Clay McCall > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
