Skip to Content
0
Former Member
Feb 10, 2006 at 04:33 PM

Refreshing multiple queries in a workbook

49 Views

Hi

I've got a workbook which has two queries in it. Both have a selection variable on date that has to be entered and both are set to refresh query when opening workbook. Unfortunately one query brings up the selection screen for the variable - the other query doesn't and returns all the data that matches the default filter. Is there any way I can get both the variable prompts to come up or can I use one variable prompt for both queries?