Thanks Michael, I will try this tonight!! On Thu, Dec 12, 2024, 3:40 PM Michael D. Setzer II <msetze...@gmail.com> wrote:
> On 12 Dec 2024 at 10:54, Craig Brown wrote: > > From: Craig Brown <craigbrow...@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+unsubscr...@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:mi...@guam.net > mailto:msetze...@gmail.com > mailto:msetze...@gmx.com > Guam - Where America's Day Begins > G4L Disk Imaging Project maintainer > http://sourceforge.net/projects/g4l/ > +------------------------------------------------------------+ > > > > -- To unsubscribe e-mail to: users+unsubscr...@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
