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

Database query and parameters 1
Excel 2007 data query parameter issue 1
Excel Query setup 0
Prompting for parameters in MSQuery to pass into a stored procedure 4
Querying Excel tables from Microsoft Query 1
How many parameterscan I use in a Query? 0
Parameters Button Greyed Out Why? 2
Parameter Query help - Not passing parameter? 3

Top