Ask Your Question
0

How to edit external data?

asked 2021-05-03 07:24:02 +0200

dellor gravatar image

For instance you have put external data in a cell from a website (Sheet -> Link to External Data) and selected that it would auto update every 60 seconds and you want to change this and make it auto update every 10 seconds, or change the link. Where is this located in order to edit it?

Also, what key can you press to instantly refresh?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2021-05-03 07:56:09 +0200

Zizi64 gravatar image

updated 2021-05-03 07:56:43 +0200

Edit - Links to External Files - select a link - Modify (button) - modify the properties - OK - Close

edit flag offensive delete link more

Comments

NIce, but would be good if I could see a list of what cells are using what link to quickly find them.

Also what key (as in key in your keyboard) can one press to refresh the cells?

dellor gravatar imagedellor ( 2021-05-03 08:01:31 +0200 )edit

"but would be good if I could see a list of what cells are using what link to quickly find them"

Use the Navigator/Linked areas. The Navigator is available from the Sidebar or from the Menu or by hitting F5.

Zizi64 gravatar imageZizi64 ( 2021-05-03 16:18:03 +0200 )edit

"Also what key (as in key in your keyboard) can one press to refresh the cells?"

You can write a macro for this task:

AOO/LO Forum En

Zizi64 gravatar imageZizi64 ( 2021-05-03 16:21:21 +0200 )edit

How can I delete stuff from the F5 list? I have deleted the cells, however the HTML_all, HTML_Tables, HTML_1 etc stuff that I have deleted still shows up on that list.

dellor gravatar imagedellor ( 2021-05-05 20:41:34 +0200 )edit

You can remove the link in the Edit menu.

Zizi64 gravatar imageZizi64 ( 2021-05-06 09:03:23 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-05-03 07:24:02 +0200

Seen: 34 times

Last updated: May 03