Search does not work for one workbook

[forums55]

I have workbook, but search (spotlight) often does not work for it.
Drives me crazy. What can this be.
I see peoples names in there.


Kevs

OS 10.6.2
INTEL imac
Office 2004

 

[John McGhie]

Hi Kevs:

It could be the file format the workbook is saved in. What extension does
the file-name have?

The extension tells the system what kind of data a file contains, which
controls which importer Spotlight uses to read the file: if there is no
extension you could get strange results.

Cheers

I have workbook, but search (spotlight) often does not work for it.
Drives me crazy. What can this be.
I see peoples names in there.


Kevs

OS 10.6.2
INTEL imac
Office 2004

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]

 

[ken]

Hi Kevs:

It could be the file format the workbook is saved in. What extension does
the file-name have?

The extension tells the system what kind of data a file contains, which
controls which importer Spotlight uses to read the file: if there is no
extension you could get strange results.

Cheers



This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]

John, thanks,
Seem to solve this by choosing to search values instead of formulas.
Why was it on formulas? Is this the default?
And is there a setting to search everything so this does not happen again?
thanks
Kevs

OS 10.6.2
INTEL imac
Office 2004

 

[John McGhie]

I believe "Formulas" is the default.

Normally, "Formulas" will also pick up Values, because the values are the
result of formulas. But if the value does not exist (because the sheet has
not fully recalculated) then it won't be there to be found.

Cheers

John, thanks,
Seem to solve this by choosing to search values instead of formulas.
Why was it on formulas? Is this the default?
And is there a setting to search everything so this does not happen again?
thanks
Kevs

OS 10.6.2
INTEL imac
Office 2004

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]