Display Excel Parameters?
Posted by Brett Holcomb on October 26, 2001 4:39 AM
Good morning.
I have imported data in my excel sheet from a microsoft access table and have created a paramteter based on a start date and finish date. Then I created a pivot table form this data and hid everything but the pivot table. Thus, when I open this spreadsheet, a dialog box appears and asks me to enter my start date and then enter my finish date. From there, I hit refresh data on my pivot table and see the results.
However, if I leave my workstation and come back 2 hours later, I someitmes forget what my initial dates were, what my parameters were. Is there any way that I can create a cell that says "Start Date:" and have my parameter start date appear and creata a cell that says "Finish Date:" and have my finish date appear?
I hope this makes sense- thanks for your help.
Posted by Bob Umlas on October 26, 2001 5:03 AM
Why not just store these in cells from your displayed dialogbox?
-----------------------------
Posted by Brett Holcomb on October 26, 2001 5:05 AM
Bob,
How would I go about doing this? That is exactly what I wnated... to have the parameter dialog box put the input value into a cell that I can see.
Posted by Mark W. on October 26, 2001 5:35 AM
> Is there any way that I can create a cell that
> says "Start Date:" and have my parameter start
> date appear and creata a cell that says "Finish
> Date:" and have my finish date appear?
Yes, when you create your parameters using the
Data | Get External Data | Parameters... menu
command you can specify that the parameter values
are to be obtained from worksheet cells. You
merely enter and store your data values in those
cells and your query will obtain them from those
cells rather than the dialog that you're currently
using. See the Excel Help Index topics for
"parameter queries", "Create a query that prompts
for criteria", and "Use data from a cell on a
worksheet as a parameter value".
Posted by Brett on October 26, 2001 6:22 AM
Thanks Mark
Mark,
Perfect, thank you.
Posted by Mark F. on October 26, 2001 8:43 AM
This is what I want to do also. Maybe somebody knows.
