Hi,
My current excel spread sheets link to each other via named cells - for example
=‘file:///C:/Users/David/Documents/ESTATE/LASTYEAR/US-FUNDS.xls’#kbsav
loads data from kbsav which is a named cell in the spread sheer US-FUNDS.xls.
This does not work in v6 of libre office. Is there an option to make it work for compatibility or must I edit each reference of this type, and if so into what form?
Thanks,
Dave
This exact syntax is used in LibreOffice. If it doesn’t work for you, you might want to provide a sample to test, and possibly (if that’s a bug e.g. in import from Excel binary formats) file a bug report on the tracker.
Mike
This is really weird. After much playing round I was able to get a set of linked spread sheets to work. The playing consisted of reading in the file and writing it out, editing the names of the external named cells in the link and editing the names of the cells in the link target. The edits deleted characters and / or reset the complete name.
I have no idea why some links work and some don’t, nor any consistent way to repair them. The error is #REF - can that be expanded in some way?
Help