MS Query Not Auto Refreshing

**JuSlaughter** · 03-15-2007, 06:14 AM

This might be a really easy fix but I can't seem to find anything on
it. Go easy on me, I'm a newbie

I have created a simple MS Query that returns 2 columns from a table,
a name and a date of birth. Within this query are 2 parameters, a from
date and a to date. On my excel 2003 spreadsheet I have 2 cells that
hold a from date and a to date. Both parameters are set to pick up the
values in these cells but will only automatically refresh once the to
date has been changed.

If I change the dates, nothing happens. But if I right-click on the
data and do Refresh Data, the update takes place. As stated, my
machine runs Office 2003 with SP2.

So, I thought I'd try the same query directly on the server. I created
the same query and excel sheet, set up the parameters in the same way,
change the values and it worked.

Whats the difference between the 2 machines. Mine has Office 2003 with
SP2, the server has Office 2003 with NO service pack. Presumably then,
something has been introduced in a service pack that has stopped the
"refresh when value changes" option.

I know what many are thinking, why use MS Query and not ADO and SQL. I
work for a company who provide systems for insurance brokers. We have
developed a process for getting our proprietry data into SQL so that
users can create custom reports, etc. The process of querying has to
be as simple as possible as many don't have the necessary skills. So,
MS Query it is.

Any info anyone can spare would be much appreciated. Thanks very much

**Loz** · 03-16-2007, 09:32 AM

I have 2003 with SP2 and it automatically refreshes when a cell linked as a parameter to an MS Query changes.

If you right-click on the query range and select Parameters, the attachment screen shot shows where you may need to check the box to ensure that the query automatically refreshes.