I'm using the following function in a parameter
=indirect("Domestic!A"&row())
It works great until I save the spread sheet. When I reopen I get the
following error message and the parm has disappeared?

Could not obtain parameter from reference (Bad name or workbook not open).
Proceed to prompt for value.

Does anyone know why this is happening? Thank You

The row() needs to reference something. Try this, assuming you are entering
the formula on row 1.

=INDIRECT("Domestic!A"&ROW(A1))

"saveas getting rid of formulas" wrote:

I'm using the following function in a parameter
=indirect("Domestic!A"&row())
It works great until I save the spread sheet. When I reopen I get the
following error message and the parm has disappeared?

Could not obtain parameter from reference (Bad name or workbook not open).
Proceed to prompt for value.

Does anyone know why this is happening? Thank You

No this had the same result.
both
=INDIRECT("Domestic!A"&ROW(A1))
and
=INDIRECT("Domestic!A"&ROW( ))
work and return the cell value correctly. I get the error when I then
save the spread sheet and try to reopen it. Thanks


"Jonathan Cooper" wrote:

The row() needs to reference something. Try this, assuming you are entering
the formula on row 1.

=INDIRECT("Domestic!A"&ROW(A1))

"saveas getting rid of formulas" wrote:

I'm using the following function in a parameter
=indirect("Domestic!A"&row())
It works great until I save the spread sheet. When I reopen I get the
following error message and the parm has disappeared?

Could not obtain parameter from reference (Bad name or workbook not open).
Proceed to prompt for value.

Does anyone know why this is happening? Thank You

No, ROW() implicitly declares the current row, the row the formula is in.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Jonathan Cooper" wrote in
message ...
The row() needs to reference something. Try this, assuming you are
entering
the formula on row 1.

=INDIRECT("Domestic!A"&ROW(A1))

"saveas getting rid of formulas" wrote:

I'm using the following function in a parameter
=indirect("Domestic!A"&row())
It works great until I save the spread sheet. When I reopen I get the
following error message and the parm has disappeared?

Could not obtain parameter from reference (Bad name or workbook not
open).
Proceed to prompt for value.

Does anyone know why this is happening? Thank You

It's a parameter to what?
--
Kevin Vaughn


"saveas getting rid of formulas" wrote:

I'm using the following function in a parameter
=indirect("Domestic!A"&row())
It works great until I save the spread sheet. When I reopen I get the
following error message and the parm has disappeared?

Could not obtain parameter from reference (Bad name or workbook not open).
Proceed to prompt for value.

Does anyone know why this is happening? Thank You

Strange. I copied your formula exactly into a worksheet, saved and
re-opened it and it worled fine.

Hans

it is a parameter for an external data source - sql server

"flummi" wrote:

Strange. I copied your formula exactly into a worksheet, saved and
re-opened it and it worled fine.

Hans