<div>
Hi there,<br />
<br />
Without being right in front of my information, I think about 27. The queries are already written and tested in SQL, hopefully, &nbsp;it's just getting everything setup properly in excel and getting the data connection setup properly.<br />
<br />
SM
</div>


Hi there,

Without being right in front of my information, I think about 27. The queries are already written and tested in SQL, hopefully,  it's just getting everything setup properly in excel and getting the data connection setup properly.

SM

<div>
Correct. Are all queries returning just one cell?<br />
In any case, this shouldn't be a problem, just follow the steps 27 times :-)
</div>


Correct. Are all queries returning just one cell?
In any case, this shouldn't be a problem, just follow the steps 27 times :-)

<div>
The only problem I run into is you are unable to assign more than one sql query per connection. &nbsp;I found a different solution by combining the queries on the SQL end.<br />
<br />
Thanks and stay tuned for another post.<br />
<br />
-Steve
</div>


The only problem I run into is you are unable to assign more than one sql query per connection.  I found a different solution by combining the queries on the SQL end.

Thanks and stay tuned for another post.

-Steve

<div>
I was going to suggest to combine them into one View/Stored proc indeed.
</div>


I was going to suggest to combine them into one View/Stored proc indeed.

<div>
<div class="content wysiwyg-content">
Hi there,<br />
<br />
As the topic states, I would like to know if and how individual cells in an excel 2007 spreadsheet can have their own unique query drawing data from my SQL 2000 RDMS?<br />
<br />
I have used pivot tables but, for this situation I think individual cell queries would be best.<br />
<br />
Thanks,<br />
<br />
--Steve
</div>
</div>


Hi there,

As the topic states, I would like to know if and how individual cells in an excel 2007 spreadsheet can have their own unique query drawing data from my SQL 2000 RDMS?

I have used pivot tables but, for this situation I think individual cell queries would be best.

Thanks,

--Steve

Creating Excel Spreadsheet with SQL queries in individual cells

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.