Re: [libreoffice-users] question regarding linking spreadsheets

On 12 Dec 2024 at 10:54, Craig Brown wrote:

From:                   Craig Brown <craigbrown09@gmail.com>
Date sent:              Thu, 12 Dec 2024 10:54:48 -0500
Subject:                [libreoffice-users] question regarding 
linking spreadsheets
To:                     users@global.libreoffice.org

> Hello!
>
> I have linked 2 spreadsheets and when I open target I am prompted with:
>
> *Security Warning Automatic update of external links has been disabled.*
>
> When I click *Allow updating*, I do not see the update that I have entered
> in the source sheet.

Allow updating is only for that connection. You have to set the 
directory of where the spreadsheet is to have it work without 
warning.

Tools / Options / Libre Office / Security / Macro Security /  Trusted 
Sources / 
Then under the Trusted File Locations you need to enter the 
directory that contains the spreadsheet that has the link.

One that I have listed is /home/msetzerii/staffx19
Have some speadsheets in that directory that link to csv files I 
create from web pages campus directory files. Without the entry, I 
would get those same messages. Note: I am using Linux so that is a 
linux path to directory, but would think same process with windows 
directory.

Took a while to find the exact process, but is directory of where the 
linked spread sheet is, and not where the linked files are.

Hope that helps.



> I thought the issue may be with the fact that these are in my OneDrive
> cloud and perhaps there is a permissions issue. I tried the same scenario
> on local drive, but had the same issue.
>
> I even tried manual update by going to *Edit-->Links to External
> Files-->Update*. Still did not update.
>
> How can I fix this so that I can see updates in the target sheet?
>
> Thanks much!
> Craig
>
> -- 
> 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