Help with referenced sheet (sorry for dups)
 

Hi all,

I am attempting to feed data into a cell on sheet ABC that comes from
another sheet that will be created programmatically (call it sheet XYZ). I
start by creating the reference with sheet XYZ already existing, so that I
can pick the cells I want off of it. I then delete sheet XYZ. My cells on
ABC all then become #REF, which is okay with me. I save and close. I then
run the program that takes some data, opens my excel file, and (re)creates
sheet XYZ and puts the data I want onto it.

The problem is that all of my cells on ABC that reference XYZ keep the #REF
until I double click in the cell and hit 'Enter'. Neither Refresh or
Calculate Sheet work.

Any ideas?

Thanks!

Bill

Help with referenced sheet (sorry for dups)
 

To get xyz!b4

=INDIRECT("xyz!B"& ROW(A4))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bill L" wrote in message
.. .
Hi all,

I am attempting to feed data into a cell on sheet ABC that comes from
another sheet that will be created programmatically (call it sheet XYZ).
I
start by creating the reference with sheet XYZ already existing, so that I
can pick the cells I want off of it. I then delete sheet XYZ. My cells
on
ABC all then become #REF, which is okay with me. I save and close. I
then
run the program that takes some data, opens my excel file, and (re)creates
sheet XYZ and puts the data I want onto it.

The problem is that all of my cells on ABC that reference XYZ keep the
#REF
until I double click in the cell and hit 'Enter'. Neither Refresh or
Calculate Sheet work.

Any ideas?

Thanks!

Bill

Help with referenced sheet (sorry for dups)
 

Worked like a charm!

Thanks!!


"Don Guillett" wrote in message
...
To get xyz!b4

=INDIRECT("xyz!B"& ROW(A4))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bill L" wrote in message
.. .
Hi all,

I am attempting to feed data into a cell on sheet ABC that comes from
another sheet that will be created programmatically (call it sheet XYZ).
I
start by creating the reference with sheet XYZ already existing, so that
I
can pick the cells I want off of it. I then delete sheet XYZ. My cells
on
ABC all then become #REF, which is okay with me. I save and close. I
then
run the program that takes some data, opens my excel file, and
(re)creates
sheet XYZ and puts the data I want onto it.

The problem is that all of my cells on ABC that reference XYZ keep the
#REF
until I double click in the cell and hit 'Enter'. Neither Refresh or
Calculate Sheet work.

Any ideas?

Thanks!

Bill

Help with referenced sheet (sorry for dups)
 

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bill L" wrote in message
. ..
Worked like a charm!

Thanks!!


"Don Guillett" wrote in message
...
To get xyz!b4

=INDIRECT("xyz!B"& ROW(A4))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bill L" wrote in message
.. .
Hi all,

I am attempting to feed data into a cell on sheet ABC that comes from
another sheet that will be created programmatically (call it sheet XYZ).
I
start by creating the reference with sheet XYZ already existing, so that
I
can pick the cells I want off of it. I then delete sheet XYZ. My cells
on
ABC all then become #REF, which is okay with me. I save and close. I
then
run the program that takes some data, opens my excel file, and
(re)creates
sheet XYZ and puts the data I want onto it.

The problem is that all of my cells on ABC that reference XYZ keep the
#REF
until I double click in the cell and hit 'Enter'. Neither Refresh or
Calculate Sheet work.

Any ideas?

Thanks!

Bill