Query's cell referenced parameter not saved

Question

Hi, I am extracting data from MS Access into Excel 2007 using MS Query.

Using Data/Connections/Properties/Definitions/Parameters, I select "Get the value from the following cell" to plug in the parameter, but this works perfectly until I save and close the file. When the file is opened I need to link up the cell references again. How do I save the cell reference parameters so they don't have to be entered each time the file is opened? If I don't do this, excel crashes when trying to refresh the pivot chart.

Thanks in advance.

Answer 1

I think this could be very useful, however, I would like Excel to keep the parameter reference. In the meantime I'll try some of the ideas on the thread you mentioned.

Thanks for your help.

Victor

Answer 2

Pivot tables don't get along with parameter queries. Check out this link for a workaround...

http://www.dailydoseofexcel.com/archives/2005/04/20/pivot-table-parameters/

---

If this post answers your question, please mark it as the Answer... Jim Thomlinson

Answer 3

Are you sure you kept the Recorder on until you finished modifying the cells?   If so, maybe post your code and perhaps someone here can see something

Vaya con Dios,

Chuck, CABGx3

Answer 4

I have tried that, but when I look at the VBA code, I don't see anything related to the parameters reference. Any suggestion?.

Thanks for your answer.

Victor

Answer 5

You might try Recordina a Macro while you do the Query setup and while making your cell changes once the data is imported, then turning off the Recorder.  Next time you want to run that Query, just run the macro and it will do both for you.

hth

Vaya con Dios,

Chuck, CABGx3