Ask Your Question
0

Vlookup, formula in xlsm file and external file as reference

asked 2013-11-12 07:15:35 +0200

TomekP gravatar image

updated 2015-08-29 13:29:51 +0200

Alex Kemp gravatar image

I have a file with formulas (xlsm format) containing external references to another file (search by VLOOKUP function). In MS Office 2010 formula looks like this:

=IF(F4="";"";VLOOKUP(F4;'\Cleanic\DzialHandlowy\Polska[Amber.xlsm]_Slownik'!$A$7:$D$32;2;FALSE))

but LibreOffice (4.1.2.3) function converts after the opening of file shortening a link to the external file to the form:

=IF(F4="";"";VLOOKUP(F4;[1]_slownik!$a$7:$d$32;2;0)) Anyone know how to control it?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2015-01-02 14:45:13 +0200

erAck gravatar image

Writing external references to .xlsx is implemented as of LibreOffice 4.3.2 and not available in earlier releases.

edit flag offensive delete link more
0

answered 2013-11-12 10:58:38 +0200

m.a.riosv gravatar image

Maybe the option in:
Menu/Tools/Options/Load_Save/General - Save - Save URLs relative to file system.
does the trick.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2013-11-12 07:15:35 +0200

Seen: 1,150 times

Last updated: Jan 02 '15