Search Feature in a linked spreadsheet

  • Thread starter Thread starter Browny
  • Start date Start date
B

Browny

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?
 
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?
 
UR right, thankyou
--
Browny


Dave Peterson said:
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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

updating linked cells 1
Refresh produces #N?A error 1
Specific words Categorizaion 1
Referencing Data in Closed Workbooks 4
Link Excel Comment to Sheet, Cell (Bookmark) 1
How to create absolue path link to another workbook (Excel 2003) 1
Adding a row in a linked worksheet 2
VLOOKUP 1

Back
Top