R
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?
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?