How to reference sheets and cells from another files

asked 2020-10-15 02:30:06 +0100

jufearca gravatar image

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

edit retag flag offensive close merge delete

Comments

Your reference should be in the form

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

Edited.

robleyd gravatar imagerobleyd ( 2020-10-15 02:40:21 +0100 )edit

reference to sheet not valid

jufearca gravatar imagejufearca ( 2020-10-15 02:45:07 +0100 )edit

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.

robleyd gravatar imagerobleyd ( 2020-10-15 03:01:57 +0100 )edit
LeroyG gravatar imageLeroyG ( 2020-10-15 10:40:02 +0100 )edit