Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
excel crashes when using parameter query that references a cell
9 views
Skip to first unread message
Robert Wickberg
Feb 10, 2010, 4:41:40 PM2/10/10
to
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?
jeanelizab...@gmail.com
Nov 13, 2013, 1:04:07 PM11/13/13
to
Did you ever get a solution/fix for this?
0 new messages