So, the image is so tiny I can’t tell what you are trying to do. I can see it is a spreadsheet, so guessing: you have links to other sheets that you want to automatically update?
Please edit your question to give more detail.
The yellow bar across the top of the :ScreenShot.bmp" says Automatic update of external links has been disabled
Enable Content
And I would prefer not to have to select “Enable Content” every time I enter a File
The part that is Opened “Edit” ->Link to External files Gives the option of “Manual” or “Automatic” BUT “Automatic” is greyed out The question is "How do I enter “Automatic” if it is greyed out??
The inactive (greyed out) [o] Automatic option applies to DDE links only (see https://help.libreoffice.org/6.3/en-US/text/shared/01/02180000.html?DbPAR=SHARED#bm_id3156156). To achieve what you intend, see my answer below (I’d agree, if you’d state, that the placement of that Automatic option for a very special case on that prominent location is beyond optimal)
Hello,
to automatically update you need to do the following:
-
Set
Tools -> Options -> LibreOffice Calc -> General -> Option: Update links when opening: [o] Always (from trusted locations) -
To set trusted locations: Use
Tools -> Options -> LibreOffice -> Security -> Button: Macro Security -> Tab: Trusted Sources -> Category: Trusted File Locations -> Button: Addto add the directory of your file(s) which you want to trust to automatically update external links.
Important: You must not select the path of the file containing the source data, but the path of the file linking to external data. In fact you define a trust relation of LibreOffice as an application to the file, which is loading external data.
If you want automatic update at some frequency (let’s say all 60 minutes = 3600 seconds) you could do that using Edit -> Links to External Files… -> Modify -> [x] Update every -> 3600
Hope that helps.
If the answer helped to solve your problem, please click the check mark (
) next to the answer.
NOPE updating cells with the " = " or copy paste link does not update data even if the workbooks are identified as trusted in macro security. there must be a bug in version 7.0
And which questions does this yelling (all caps) answer? And as you can see, OP accepted the answer as correct - hence you seem to refer to some other problem/question (may be your own which is releated to DDE and this question doesn’t deal with DDE).
I had the same problem until just now.
The answer above is correct in that it sets the parameters required by LibreOffice.
I also tried the above answer and got the same results repeatedly.
Here is how I solved me issue.
Selected the cell> Ctrl+C
Opened the second file/sheet and selected the cell I wanted to copy to,
right click the cell then >Paste Special>Paste Special>Link (This copied the location of the file) I closed it then opened it again. The file did not update.
What I had to do for it to update automatically was to select the cell again and edit the file name from
1’
to the actual file name, e.g
=‘file:///C:/Users/L/D/20/Tate/1’#$Dec.I3 Changed-To =‘file:///C:/Users/L/D/20/Tate/test123’#$Dec.I3
I then file and exit
I opened the file and all the links had updated correctly. I repeated this process several time to make sure it worked!
Hope this wasn’t too confusing.