On 5 Dec 2025 at 9:41, Susanne Mohn (LibO) wrote: From: "Susanne Mohn \(LibO\)" <[email protected]> To: <[email protected]>, "'Regina Henschel'" <[email protected]>, <[email protected]> Subject: AW: [libreoffice-users] Having issue with External links in calc. Date sent: Fri, 5 Dec 2025 09:41:21 +0100
> Moin moin > > Which Configuration you have at > Tools> Options > Security > Options? : Block any links from documents not > among trusted localc Thanks for the info. Had used the spreadsheets on another machine for many years with no problems. Moved to a different machine months ago, and thought I had done all the updates. All the other ones on users files from the staffx19/CONTACTD directory, but this one has a file in staffx19/CONTACTD and one in just staffx19? But it wasn't showing the macro error message one would normally see. Had done a test on another machine with Fedora 43 with newer version of Libreoffice. It showed the Macro Error since neither directory was included. Added both, and it worked fine on Fedora 43. So, just one missing trusted directory, but not seeing the error message. So, Now works fine. So, trust doesn't go with the spreadsheet, but with the installation?? Thanks. > If this is activated, you can't automatically update your document. > In Germany it is a recommendation from the BSI to deactivate it. > > Sorry about my bad english > > Susanne > > > > -----Ursprüngliche Nachricht----- > Von: Michael D. Setzer II <[email protected]> > Gesendet: Freitag, 5. Dezember 2025 00:04 > An: Regina Henschel <[email protected]>; [email protected] > Betreff: Re: [libreoffice-users] Having issue with External links in calc. > > 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 > > > > -- > 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
