Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have parameter's set-up in Excel for data that changes. My prompts a
e.g. =[Enter Date] I don't have a problem with the parameter itself actually working. But instead - when I used the Data/Refresh button, the prompt appears but there are no words, - the "Enter Date" does not appear, it is just a blank parameter box. When I have more than one parameter in a query it makes it hard to figure out what info I am supposed to be entering when. If I go in to Data/Import External Data/Edit Query, then hit the refresh button in there, the words appear, then if I go back to my spreadsheet and use the refresh command the words appear again. But if I save, close, then go back in, the words do not appear until I go back in to Edit Query. Any suggestions??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
entering parameter criteria MS Query | Excel Discussion (Misc queries) | |||
Does the COUNTIF criteria parameter accepts functions? | Excel Worksheet Functions | |||
How to count a range of number to a given parameter or criteria. | Excel Worksheet Functions | |||
Parameter/Criteria option not available for External Data Query | Excel Discussion (Misc queries) | |||
Using Autofilter to prompt for criteria | Excel Programming |