Search Feature in a linked spreadsheet
 

I have a masted workbook and a secondary workbook which is linked. the
secondary workbook must be 'updated' when opened. i've found that i cannot
search (CTL F) the secondary to find the data i'm looking for?
is this due to the formulas in the secondary sheet and not real data?

--
Browny

Search Feature in a linked spreadsheet
 

What happens when you try ctrl-f (or edit|find)?

On the edit|find dialog, you can click on the Options button and look in
formulas or values or comments (along with a few other choices).

Are you sure that they're set the way you want?

Browny wrote:

I have a masted workbook and a secondary workbook which is linked. the
secondary workbook must be 'updated' when opened. i've found that i cannot
search (CTL F) the secondary to find the data i'm looking for?
is this due to the formulas in the secondary sheet and not real data?

--
Browny

--

Dave Peterson

Search Feature in a linked spreadsheet
 

UR right, thankyou
--
Browny


"Dave Peterson" wrote:

What happens when you try ctrl-f (or edit|find)?

On the edit|find dialog, you can click on the Options button and look in
formulas or values or comments (along with a few other choices).

Are you sure that they're set the way you want?

Browny wrote:

I have a masted workbook and a secondary workbook which is linked. the
secondary workbook must be 'updated' when opened. i've found that i cannot
search (CTL F) the secondary to find the data i'm looking for?
is this due to the formulas in the secondary sheet and not real data?

--
Browny

--

Dave Peterson