I have a spreadsheet that links to a second LO spreadsheet and I cannot set this to automatic updates because LO sees the files as a Graphic File. I have no graphics in either spreadsheet. How can I get this designation off what I assume is the file being linked?
LO Max 24.8.1.2
OS Sequoia 15.0.1
Not every ālinkā is a datasource. How did you link the other file? If you donāt know upload a (reduced) version of your file.
.
At the moment I can only guess you search something like a DDE-link:
https://wiki.documentfoundation.org/Documentation/Calc_Functions/DDE
Happens quite often when you dump clipboard contents into a document, e.g. content from web pages. menu:Edit>Linksā¦ should reveal the link(s).
Not willing to upload the calc file.
What I have in various fields is this:
=āfile:///Users/asher/Documents/1Stuff/_Sheets/24 Fam Bgt.odsā#$'Credit Cardsā.H650
to bring in an amount from another calc file on my computer just to bring in a dollar amount. I do not copy and paste anything from outside another calc file on my computer and nothing with graphics.
I will look for a way to include the screen shot of the Edit Links for this document. Cannot find.
The Edit Links just shows:
Source file as: 24 Fam Bgt.odt Type: Document Status: Manual
Source File: file:///Users/asher/Documents/1Stuff/_Sheets/24 Fam Bgt.ods (There are two spaces in that name)
Type: Document
Update: Manual with that area greyed out.
Updated LO to 24.8.2.1 but no changes.
I think you should study Bug 109283 - DDE Link in Calc file cannot be changed from Manual to Automatic update any more: needs documentation update to see how to create an automatic DDE link.
It should look more like
=DDE("soffice";"H:\AskLibreOffice\RandomData.ods";"Sheet1.C3")
Help on DDE Function can assist too Spreadsheet Functions
Cheers, Al
@EarnestAl: you are likely confused. The issue you link to, talks about the change that turned insertion of DDE links into insertion of normal references (because DDE is considered obsolete/incompatible). It is unclear why DDE should be used (at least unclear when reading that issue).
OP writes something like ābecause LO sees the files as a Graphic Fileā; that needs clarification, and also the specific steps they do, specific effects they expect to see, and what specifically they see instead.
@DB3297
Register the folder in which the source file is located as a trusted storage location.
Tools - Options... - LibreOffice - Security - Macro Security... - Trusted Sources - Trusted File Locations.
General - update
I did register the folder over a year ago and should have stated that. I have also checked from time to time to make sure it is still registered.
I will go read the bug report and see what I can learn from that.
Thank you this worked. I appreciate the help.
I think this is from the Help linked from External Links dialogue where, under Automatic, it says āLinked graphic files can only be updated manually. This option is not available for a linked graphic fileā.
.
The heart of the question is āI cannot set this to automatic updatesā. The answer to that from the same Help gives a misleading answer āpasting by choosing Edit - Paste Special, and then selecting the Link boxā which is what the bug report is about.
