Ask Your Question

Error: when use indirect formula to link external data [closed]

asked 2013-09-17 03:42:48 +0200

Chansit gravatar image

updated 2015-11-09 04:09:21 +0200

Alex Kemp gravatar image

I found data link error when I try to open file that contain manual link with function INDIRECT. In LO 4.0.4,4.0.5, 4.1.1

example. I use file name and address in cell B2 ('HostLink.ods'#$Sheet1.A1), the B3 formula "=INDIRECT(B2)", I place all file in c:\My Document

After I open file cell B3 return "#REF!". With error message

"The following external file could not be loaded. Data linked from this file did not get updated. file:///D:/DATA/HostLink.ods"

However, after I made chang with file (input value in cell / Show/Hide Column) B3 will link data from source correctly.

I 'm sorry, i can't attach file

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-09 04:09:36.362800


I found the same problem in LO

Chansit gravatar imageChansit ( 2013-10-05 13:59:13 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-09-18 03:42:27 +0200

Chansit gravatar image

By default, if there is not path in string when using INDIRECT() calc will use current folder of file, but this case calc use default "My Document" path in setting.

I not found this error in LO 4.0.1 - 4.0.3

edit flag offensive delete link more


if I change file folder to other folder, I will receive this error too.

Chansit gravatar imageChansit ( 2013-09-18 03:47:06 +0200 )edit

answered 2013-09-17 20:53:32 +0200

m.a.riosv gravatar image

updated 2013-09-17 20:54:09 +0200

Maybe the issue is that using INDIRECT() there is not know the actual link path before a first calculation.

edit flag offensive delete link more


Thank you for your answer.

Chansit gravatar imageChansit ( 2013-09-28 14:05:29 +0200 )edit

Question Tools

1 follower


Asked: 2013-09-17 03:42:48 +0200

Seen: 791 times

Last updated: Sep 18 '13