Vlookup, formula in xlsm file and external file as reference

[TomekP]

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?

[mariosv]

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

[erAck]

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