Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Using Excel 2007.
I have a table with a database query which contains parameters. The SQL for the query looks like: {Call p_GetData(?, ?) } and the parameter is named. Let's say that this is on a sheet called QuerySheet. Let's say there is another sheet called DataSheet. It has a cell on it which is named "ImportantData" When I right click on the table on the sheet, and bring up the Parameters form, I can see that both parameters are marked "Refresh automatically when cell value changes" The cell that the parameter is tied to is calculated on another sheet, but I have a cell on the sheet that contains the query, which duplicates the value, i.e. QuerySheet!$A$1 is set to =ImportantData, and Parameter1 for the query is set to QuerySheet!$A$1 When I change the value on the DataSheet, and switch back to QuerySheet I see that QuerySheet!A1 has been updated, but the query has not been re-run. I notice that there was a SP for Office 2000 that fixed a problem that seemed related, but I don't see anything regarding the problem in Excel 2007. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Parameter queries in Excel 2007 | Excel Discussion (Misc queries) | |||
MS query--can it handle parameter queries from Access? | Excel Discussion (Misc queries) | |||
Queries on Pivot table | Excel Discussion (Misc queries) | |||
Where can I learn how to create parameter queries in Excel? | Excel Discussion (Misc queries) |