How to reference sheets and cells from another files

[jufearca]

Hello everyone, I’m trying to make a reference in libreoffice calc using ubuntu, the error I have is reference to sheet not valid, I need to consolidate data from several files, so the second resource is in /home/file.odt$Sheet1.$A$1:$E$4, I am looking for information about how to resolve it, and I asked in ask libreoffice, thanks in advance

[robleyd]

Your reference should be in the form

file:///path/toyourfile/filename.ods'#$Sheet1.A2:A15

Edited.

[jufearca]

reference to sheet not valid

[robleyd]

Perhaps you might give a little more information, for example the exact formula you are using and the exact error message you receive. Edit your question to add this information.

And please remember that we can’t see your screen so we need to depend on accurate information from you to try and resolve your problem.

[LeroyG]

Duplicated of Calc, agregar referencia a determinada celda o rango de celdas, de determinada hoja, de un archivo diferente.