Cross-referencing data across sheets (Calc)

English
#1

Hello,

I’m trying to cross-reference data for a calculation across at least two different sheets within the same file.
However, this used to work and now it stopped.

Example:
Sheet-A, cell L39 contains the figure 100. I want to make it part of a summary of several sheets in cell B2 in sheet-B.

So I usually go into cell B2 on sheet-B, say = then switch to sheet-A, click into cell L39 and press enter.
The result should be =$'sheet-A'.L39 in cell B2 of sheet-B and it displays the figure 100 of cell L39 in sheet-A.
But that won’t work anymore. All it displays is the = sign in cell B2 on sheet-B
Am I missing something? Has something changed with an update or so?

#2

Give the relevant areas names, then you can dispense with cell references.

Untitled#132369.ods (9,0 KB)

#3

Interesting. When I opened your example sheets it was possible to do it the usual way.
I attached it again with a few more cells filled- the way I used to do this.
Why would naming areas be necessary sometimes and at other times not? I’m just confused by this…
untitled.ods (8.6 KB)

#5

@GBano
I’d try opening Calc without specifying a file, then, in the blank sheet, fill in cells to test the way you are used to doing it.

#6

It is not necessary, but in certain cases it may simply be more convenient.

#7

Please show a screenshot of this,
or even better: upload a sample file (calc) with the problem.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.