Re: [libreoffice-users] Having issue with External links in calc.

On 5 Dec 2025 at 9:41, Susanne Mohn (LibO) wrote:

From:                   "Susanne Mohn \(LibO\)" 
<Susanne.Mohn-lo@kiel-pries.de>
To:                     <msetzerii@gmail.com>,
        "'Regina Henschel'" 
<rb.henschel@t-online.de>,
        <users@global.libreoffice.org>
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 <msetzerii@gmail.com> 
> Gesendet: Freitag, 5. Dezember 2025 00:04
> An: Regina Henschel <rb.henschel@t-online.de>; users@global.libreoffice.org
> 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:                   users@global.libreoffice.org
> From:                 Regina Henschel 
> <rb.henschel@t-online.de>
> 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: users+unsubscribe@global.libreoffice.org
> > 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:mikes@guam.net                            
>  mailto:msetzerii@gmail.com
>  mailto:msetzerii@gmx.com
>  Guam - Where America's Day Begins                        
>  G4L Disk Imaging Project maintainer
>  http://sourceforge.net/projects/g4l/
> +------------------------------------------------------------+
>
>
>
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
> 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:mikes@guam.net                            
 mailto:msetzerii@gmail.com
 mailto:msetzerii@gmx.com
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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