LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default prompt for parameter/criteria

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
entering parameter criteria MS Query KM01 Excel Discussion (Misc queries) 0 April 29th 10 12:46 PM
Does the COUNTIF criteria parameter accepts functions? [email protected] Excel Worksheet Functions 3 May 22nd 08 09:50 AM
How to count a range of number to a given parameter or criteria. Saul Excel Worksheet Functions 4 October 26th 07 11:32 PM
Parameter/Criteria option not available for External Data Query rael_lucid Excel Discussion (Misc queries) 2 April 11th 06 03:48 AM
Using Autofilter to prompt for criteria Rob Excel Programming 1 January 20th 06 05:50 PM


All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"