Link to External Data not Updating [closed]

asked 2021-04-22 18:10:55 +0200

NevGi gravatar image

updated 2021-06-10 21:00:02 +0200

Alex Kemp gravatar image

I created a link to external data with a real time crypto market data from link (spammy-link removed) and i set it to 60secs for every update and it worked fine. It was auto-updating every 60 sec and i was also able to manually update it from edit>links to external files then I was satisfied thinking it was working so I saved it and closed the document. But later when i reopened the document i see that the link was not auto-updating every 60 sec and i also became unable to manually update it from edit>links to external files as it became greyed out. So how can i fix this.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by NevGi
close date 2021-04-23 10:56:36.855469

Comments

  • Close the file
  • Open the file

Do you get the following Info Bar?

image description

Opaque gravatar imageOpaque ( 2021-04-22 18:46:30 +0200 )edit

"But later when i reopened the document i see that the link was not auto-updating every 60 sec"

What file type are you using?

Zizi64 gravatar imageZizi64 ( 2021-04-22 18:55:07 +0200 )edit

No I dont get that alert after reopening my doc. Before saving and closing the document i was able to go from menu>edit>link to external files to edi the link and manually update it but later after reopening the doc the edit>link to external files was greyed out so couldn't edit or manually update it.

NevGi gravatar imageNevGi ( 2021-04-23 05:19:47 +0200 )edit

Are you using a native, international ODF file format, or you using a foreign, obsolete file format?

Zizi64 gravatar imageZizi64 ( 2021-04-23 10:21:39 +0200 )edit

No I was using the excel file format(.xlsx). But now when i used the external data link in the naitive format(.odf) after what you said. Now my document works as intended and i can now update link manually and automatically.

NevGi gravatar imageNevGi ( 2021-04-23 10:29:32 +0200 )edit

"But now when i used the external data link in the naitive format(.odf) after what you said."

Just for clarify:

ODF = Open Document Format (general name)

.odf = Open Document Formula (for the equation editor)

.ods =Open Document Spreadsheet. (for the spreadsheets)

Zizi64 gravatar imageZizi64 ( 2021-04-23 16:11:23 +0200 )edit

Oh yeah its .ods not .odf file type.

NevGi gravatar imageNevGi ( 2021-04-23 16:26:23 +0200 )edit