In Calc, when we use the functio VLOOKUP, exemple: =VLOOKUP(A1686;'file:///Y:artigos.xls'#$Sheet2.A$2:D$7922;4;FALSE()) and save as Microsoft Excel 97/200/XP (.xls), the next time that we open that file .xls, we most decide to update or not the file because the file contains links to other files, but in cell, we have the error message Err:502, because the array function is not correct, the same exemple open after save as .xls: =VLOOKUP(A1686;'file:///Y:artigos.xls'#$''.A$2:D$7922;4;FALSE())
This one is a DUP of
Bug 32717 - Wrong cell links when saving in Excel XP format
Thank you for your attention!
Can you please try to find more meaningful summaries? Hints on
might be useful for you!
*** This bug has been marked as a duplicate of bug 32717 ***