On 4 Dec 2025 at 19:30, Regina Henschel wrote: Subject: Re: [libreoffice-users] Having issue with External links in calc. To: [email protected] From: Regina Henschel <[email protected]> Date sent: Thu, 4 Dec 2025 19:30:00 +0100
> Hi Michael, > > Michael D. Setzer II schrieb am 04.12.2025 um 18:54: > > Have a spreadsheet that has external links to two csv files > > Operating system? > > Do you see the links in menu Edit > Links to external files... ? > > and it > > has worked for many years. But just opened it, since the main data > > file is only updated every 3 months, and noticed it was not linking > > to the new data? > > No longer linked or do not update automatically? > Did some more testing. Fedora 42 Version: 25.2.7.2 (X86_64) Build ID: 520(Build:2) CPU threads: 8; OS: Linux 6.17; UI render: default; VCL: gtk3 Locale: en-US (en_US.utf8); UI: en-US Calc: threaded Here is what I had happen before. Would open the streadsheet with this libreoffice staffingCampusA.ods It would then link to CONTACTD/moredir.csv and morestaff.csv Now it doesn't updated info. Tried adding 1000 to the first field of both files before opening, but after opening it still shows same data. Used Edit External Links and it shows status as unavailable? Click on update for both links, and data remains the same. Try breaking links and recreating links, and redoing update, and again no changes. Then break links, and save spreadsheet. Reopen, and redo the links again, and it works just fine?? Data is then updated. But try again, and no updates? My other option that does work, is open the 3 files together, and then manually copy the cell from the two cvs files to the correct locations. libreoffice --infilter=CSV:44,34,76,1,,,,true morestaff.csv CONTACTD/moredir.csv staffingCampusA.ods The staffing pattern file is only updated ever 3 months, and the moredir.csv comes from Campus Directory, that has changes much more often. Even tried touching the files before opening spreadsheet thinking it might be seeing the speadsheet as being newer than files, but made no difference. So for moment, have modified the script to option the 3 files, and do a manual copy since external link is showing Not available, while files are exactly there, and then clicking on update changes that to Manual, but it isn't updated?? Thanks for reply. > Kind regards, > Regina > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy +------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:[email protected] mailto:[email protected] mailto:[email protected] Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
