G
Guest
I have parameter's set-up in Excel for data that changes. My prompts are:
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???
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???