MS Query Question

berniean

New Member
Joined
Nov 10, 2009
Messages
5
I use MS Query extensively with data from both MS Access queries and MS Excel spreadsheets. I am currently using Excel 2010. Lately, when I refresh the query, Excel opens the source spreadsheets, even if they are tied to the Access query. This is not only annoying, it is a time-sink since I have to close all the source files. There is also the fact that some of my spreadsheets are shared and the users shouldn't see the source data. Does anyone know why this might happen and how I can prevent it? I have examined the MS Query definition and don't see a check box or anything else that would cause this. Any help is greatly appreciated.
 

Forum statistics

Threads
1,085,724
Messages
5,385,515
Members
401,957
Latest member
Socksnpants

Some videos you may like

This Week's Hot Topics

Top