Automatic update

[pruleone]

Hy,

I have linked data from internet to my excel sheet.
Every time I open my workbook it asks from me to I want to enable automatic refresch.

Is it any way possible, that if I open workbook, then it dosen't ask me that question. Same time data would be automaticly updated anyway?

 

[kjv1611]

Yes.

If Excel 2003 or before, try right-clicking anywhere in your data, and looking under connection properties. There should be an option there that'll work.

Or if Excel 2007, on the Data tab of the ribbon, click the drop-down arrow under "Refresh All" and choose "Connection Properties"... Or click "Connections" ,and then "Properties", assuming the one connection is already selected.

If it's not there, I'm sure the option is available, but I just can't think exactly where it is. I'm also guessing you're using Excel 2003 or older, and I've now been moved to 2007, so I can't verify about 2003 by looking.

Let us know if that or something else works.

Otherwise, take a look at the possibilities here:

http://tinyurl.com/d4ajg5

--

"If to err is human, then I must be some kind of human!" -Me

 

[pruleone]

Thank you for that information - that link was very cool

But,

I find away that excel dosen't ask me question, when I open workbook. But this means also, that there aren't automatic update.

I filled in external data rande properties enable background refresh but I had to unselect refresh every x minutes and refresh data on file open.

Can anybody help me write somekind of macro which would run when I open workbook and would to automatic update?

I found away to create a putton, so when I press it, it will force excel to do update. But this solutions isn't good for me.

 

[kjv1611]

If you've already got the code working behind a button, then you could just move that code to the workbook's "On Open" event:

http://www.ozgrid.com/VBA/auto-run-macros.htm

But if you want/need to go further than that with VBA, you'll probably be best served to repost your question with VBA in mind over at this forum:

http://www.tek-tips.com/threadminder.cfm?pid=707

--

"If to err is human, then I must be some kind of human!" -Me

 

[SkipVought]

kjv meant forum707.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[kjv1611]

Yeah, that one.

Boy, 2 booboos within minutes! Whoda thunk it! Oh yeah, me.

--

"If to err is human, then I must be some kind of human!" -Me