Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2007 Refreshing Data Connections & pass in parameter

Status
Not open for further replies.
Dec 27, 2007
56
US
I have a spreadsheet with connections to four SQL Server stored procedures. Each one returns data for a graph. The graphs are all on one page, making a kind of ersatz dashboard.

When I click the refresh button, the screen jumps four times, once for each SP. Is there a way to smooth that out somehow? This is my first data connection to SP/spreadsheet and other than this and one other thing, it's going well.

The "one other thing" is that I can't find a way to pass in a parameter. The documentation says the format is {CALL SPname,?,?} and it's supposed to prompt for the parameter or even allow you to specify a cell where the parameter will be entered. I can't figure out how to do that.

Some advice I've received is 2003 specific and didn't work. I think external querying has changed somewhat with 2007.
Any Excel 2007 advice would be much appreciated - thanks!
 
Bump - Does anyone please have a thought on these two questions? I'm stumped! Thanks!
 
1: Application.screenupdating = false

2: How are you "refreshing"? Are you using a querytable or running through ADO?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top