excel crashes when using parameter query that references a cell


Robert Wickberg

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, or even if I
save the spreadsheet, then reopen it, then immediately save it without
fixing this. How do I fix this so my cell reference will be saved?

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