I want to link a cell on sheet 2 (in calc) and populate it with a value from sheet 1

Have used the example =Sheet1!C45 ? given (with and without the query) and get err 509 or #NAME?

Hello peter, you could try “Sheet1.C45”

Where did you get the example from? It’s Excel style.

Lupp, I got that from the Libre Wiki
Librebel, thta just enters text into the cell in sheet 2

sorry, try “=Sheet1.C45” ( with the “=” in front)

Maybe the issue is in relation with the formula configuration, =Sheet1!C45 is an excel syntax.

Menu/Tools/Options/LibreOffice Calc/Formula syntax

hello peter,

1) place the cursor into your cell on Sheet 2
2) type "=Sheet1.C45" (without the quotes) and press Enter

Librebel, you are a genius, it WORKS.
As always, I was looking for a too complicated a formula !
So easy for me to do so
Thank you so much…
Pete

you’re welcome:)