I've got an external data query that gets the value from a cell (vendor
number) and refreshes the spreadsheet. I'd really like another parameter
that references a second cell but I haven't gotten this to work yet. I need
the second parameter to be process level 'PSBP' or 'ZERO'. I'm adding this
after the fact; the process level should really be the first parameter with
the vendor number second. If you set the process level parameter to refresh
automatically and then go after the specified vendor number, how do you keep
the process level? When you key a different vendor number the second refresh
would ignore the process level wouldn't it?

So you have a MS query with a single parameter now. If you go into the query
you can add a second parameterized criteria. Now when you get back to your
spreadsheet you can add an additional cell link for your new parameter. Both
cell values will be passed into the query when it is refreshed. One thing ot
note is that if you are refreshing on cell change then when either parameter
cell is changed the query will run which may not be what you want to happen...
--
HTH...

Jim Thomlinson


"cottage6" wrote:

I've got an external data query that gets the value from a cell (vendor
number) and refreshes the spreadsheet. I'd really like another parameter
that references a second cell but I haven't gotten this to work yet. I need
the second parameter to be process level 'PSBP' or 'ZERO'. I'm adding this
after the fact; the process level should really be the first parameter with
the vendor number second. If you set the process level parameter to refresh
automatically and then go after the specified vendor number, how do you keep
the process level? When you key a different vendor number the second refresh
would ignore the process level wouldn't it?

Thanks Jim!

"Jim Thomlinson" wrote:

So you have a MS query with a single parameter now. If you go into the query
you can add a second parameterized criteria. Now when you get back to your
spreadsheet you can add an additional cell link for your new parameter. Both
cell values will be passed into the query when it is refreshed. One thing ot
note is that if you are refreshing on cell change then when either parameter
cell is changed the query will run which may not be what you want to happen...
--
HTH...

Jim Thomlinson


"cottage6" wrote:

I've got an external data query that gets the value from a cell (vendor
number) and refreshes the spreadsheet. I'd really like another parameter
that references a second cell but I haven't gotten this to work yet. I need
the second parameter to be process level 'PSBP' or 'ZERO'. I'm adding this
after the fact; the process level should really be the first parameter with
the vendor number second. If you set the process level parameter to refresh
automatically and then go after the specified vendor number, how do you keep
the process level? When you key a different vendor number the second refresh
would ignore the process level wouldn't it?