| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a search feature in a worksheet | Links and Linking in Excel | |||
| How do I create a macro with a variable search feature? | Excel Discussion (Misc queries) | |||
| Excel list feature should search with more than first character | Excel Worksheet Functions | |||
| Search feature not too helpful | Excel Discussion (Misc queries) | |||
| Search feature in workbook | Excel Worksheet Functions | |||
Linear Mode
