Thread: trouble with parameter query

I'm trying to make a parameter query using a cell as a holding spot for the parameter. I ciick connections, then properties, then the definiition tab, then parameters. One choice there is "get the value from the following cell". I click on the cell, it puts in a cell reference, then I ok everything and back out. It works fine, but when I go to save the spreadsheet, then retrieve it, the cell reference is gone! Excel crashes if I try to do a refresh of the data without going back to that spot and reentering the cell number. How do I fix this?