Excel not saving query parameters

V

Viesis

Hi,

I have folowing problem... it seems like excel problem... who
knows....
using excel 2007

I've created simple macro enabled excel workbook. Then I use Microsoft
Query to access one of my SQL Server tables ... create query with
parameter.
Then I use excel "Parameters" dialog to set parameter as a reference
to specific cell. everything works fine....
however when i close and reopen excel file parameters setup is lost...
how to preserve parameter setup?
 
R

Robert Bergs

Hi,
I'm having exactly the same problem in MS Excel 2007 & I came across this thread - I see you posted a while ago but did you ever find a solution or workaround?
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating parameters in excel for an access-linked query 0
Excel does not accept text format! 0
Database query and parameters 1
How to pass parameters to excel from wscript (Windows script) 5
OLE DB Query in Excel 1
Microsoft Query: Parameter Query? 2
Office 10 Crosstab query with Parameters 0
SQL query in excel (VB) using multiple parameters 0

Top