"Update All" button for Links

[PatrickDickey_102]

Hello there,

I'm migrating over from Excel, and have a spreadsheet with 35 different "sheets" in it. Basically it's a stock investment template and the sheets are external links to finance.yahoo.com for updating the quotes. In Excel, there was a "Refresh All Connections" under their Data menu (or Data Ribbon). I don't see anything similar in Calc.

I have the links set up to automatically update (and they do for the most part). However, I like to be able to manually check them. It's not practical to open Edit -> Links, and click Update for each link because of the number of connections.

So, my question/suggestion is this: Is there a way to manually update all of my external links at once? If not, is that a feature that is being planned?

Thanks, and have a great day:)
Patrick.

[Charlie Young]

Hello there,

...my question/suggestion is this: Is there a way to manually update all of my external links at once? If not, is that a feature that is being planned?

Thanks, and have a great day:)
Patrick.

This macro should do it. It could be attached to a button or a menu choice, if it works as desired.

Code: Select all

Sub RefreshAll
	Dim Doc as Object
	dim x as Object
	dim a as Object
			
	Doc=ThisComponent
	x=Doc.AreaLinks.CreateEnumeration
	Do While x.hasMoreElements()
		a=x.NextElement()
		a.Refresh
	Loop
End Sub

[mriosv]

Don't work hard recalc Shift+Ctrl+F9?

[Charlie Young]

Don't work hard recalc Shift+Ctrl+F9?

No, that doesn't refresh external links.

[PatrickDickey_102]

Hello there,

...my question/suggestion is this: Is there a way to manually update all of my external links at once? If not, is that a feature that is being planned?

Thanks, and have a great day:)
Patrick.

This macro should do it. It could be attached to a button or a menu choice, if it works as desired.

Code: Select all

Sub RefreshAll
	Dim Doc as Object
	dim x as Object
	dim a as Object
			
	Doc=ThisComponent
	x=Doc.AreaLinks.CreateEnumeration
	Do While x.hasMoreElements()
		a=x.NextElement()
		a.Refresh
	Loop
End Sub

I created the Macro, and saved the document. I'll have to wait until tomorrow (after the markets are opened) to find out if it works. If so, how would I go about attaching it to a button (either on one of the toobars, or somewhere else)?

Thanks, and have a great day:)
Patrick.

[R_Cies]

Don't work hard recalc Shift+Ctrl+F9?

No, that doesn't refresh external links.

Yes it does but only when the source file is open. You can also record a macro and press Shift+Ctrl+F9 . I use LibreOffice 3.3