M
Me
All,
I am one of several offices supported by a purchasing group. This purchasing
group maintains the status of all purchases in an Excel workbook. They will
not open up the workbook for all. I have convinced them to let me create a
workbook that queries theirs and returns just my offices purchases. They
will have given everyone access required so that the query will work. As
long as the exact location is not readily available and all of the data is
not available, they are happy.
Everything worked great for two weeks, but a week ago when the data is
refreshed, the entire source workbook is opened. No error message or any
other indications are provided. How can I stop the query source workbook
from opening. I have searched Microsoft online help and TechNet but have not
been able to locate anything.
Thanks in advance.
Ray
moonDASHrayATverizonDOTnet
Make the obvious substitutions
I am one of several offices supported by a purchasing group. This purchasing
group maintains the status of all purchases in an Excel workbook. They will
not open up the workbook for all. I have convinced them to let me create a
workbook that queries theirs and returns just my offices purchases. They
will have given everyone access required so that the query will work. As
long as the exact location is not readily available and all of the data is
not available, they are happy.
Everything worked great for two weeks, but a week ago when the data is
refreshed, the entire source workbook is opened. No error message or any
other indications are provided. How can I stop the query source workbook
from opening. I have searched Microsoft online help and TechNet but have not
been able to locate anything.
Thanks in advance.
Ray
moonDASHrayATverizonDOTnet
Make the obvious substitutions