Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Hello!
How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#2
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
You need to Set file types and Search Location also.
Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#3
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Thanks Bob I for replying.
That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#4
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Is the Location actually accessible? As in NOT a hidden or system folder?
Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#5
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Thanks Bob I for your questions!
Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#6
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
I am puzzled as to why it is not finding the file then. Have you tried
several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#7
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Thanks Bob I for your helping questions!
Yes, the search criteria is being added to the "includes". It was working before partially. It did not find all files. I have tried Windows 2000 file search. It did not find the excel file by a number in its cell too. Best regards, Dima "Bob I" wrote: I am puzzled as to why it is not finding the file then. Have you tried several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#8
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Perhaps the text that you are searching for and the "number in Excel"
are not the same thing? They only appear similar to the user? Dima wrote: Thanks Bob I for your helping questions! Yes, the search criteria is being added to the "includes". It was working before partially. It did not find all files. I have tried Windows 2000 file search. It did not find the excel file by a number in its cell too. Best regards, Dima "Bob I" wrote: I am puzzled as to why it is not finding the file then. Have you tried several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#9
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Thanks Bob I for your thought!
There is no a "number in Excel", but only "text or property" in the Property list in the Advanced file search. Why does not the "text or property" search for a number in the Excel? How to find an Excel file with the number in its cell then? Best regards, Dima "Bob I" wrote: Perhaps the text that you are searching for and the "number in Excel" are not the same thing? They only appear similar to the user? Dima wrote: Thanks Bob I for your helping questions! Yes, the search criteria is being added to the "includes". It was working before partially. It did not find all files. I have tried Windows 2000 file search. It did not find the excel file by a number in its cell too. Best regards, Dima "Bob I" wrote: I am puzzled as to why it is not finding the file then. Have you tried several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#10
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
The numbers you see when you view a spreadsheet in Excel are not the same
as the data stored in the .xls file. No general search tool will be able to find such numbers unless is is capable of parsing the .xls file format and interpreting the contents. That's why you can search for numbers from withing Excel but not from an external function. In microsoft.public.office.misc Dima wrote: Thanks Bob I for your thought! There is no a "number in Excel", but only "text or property" in the Property list in the Advanced file search. Why does not the "text or property" search for a number in the Excel? How to find an Excel file with the number in its cell then? Best regards, Dima "Bob I" wrote: Perhaps the text that you are searching for and the "number in Excel" are not the same thing? They only appear similar to the user? Dima wrote: Thanks Bob I for your helping questions! Yes, the search criteria is being added to the "includes". It was working before partially. It did not find all files. I have tried Windows 2000 file search. It did not find the excel file by a number in its cell too. Best regards, Dima "Bob I" wrote: I am puzzled as to why it is not finding the file then. Have you tried several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 -- Gary L. Smith Columbus, Ohio |
#11
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Thanks Gary Smith for your explanation!
The Excel (Office) File search is not an external function. It is called up from the Excel File menu. Best regards, Dima "Gary Smith" wrote: The numbers you see when you view a spreadsheet in Excel are not the same as the data stored in the .xls file. No general search tool will be able to find such numbers unless is is capable of parsing the .xls file format and interpreting the contents. That's why you can search for numbers from withing Excel but not from an external function. In microsoft.public.office.misc Dima wrote: Thanks Bob I for your thought! There is no a "number in Excel", but only "text or property" in the Property list in the Advanced file search. Why does not the "text or property" search for a number in the Excel? How to find an Excel file with the number in its cell then? Best regards, Dima "Bob I" wrote: Perhaps the text that you are searching for and the "number in Excel" are not the same thing? They only appear similar to the user? Dima wrote: Thanks Bob I for your helping questions! Yes, the search criteria is being added to the "includes". It was working before partially. It did not find all files. I have tried Windows 2000 file search. It did not find the excel file by a number in its cell too. Best regards, Dima "Bob I" wrote: I am puzzled as to why it is not finding the file then. Have you tried several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 -- Gary L. Smith Columbus, Ohio |
#12
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Actually as I understand it, the file search function is a separate Office
function that is invoked by Excel, Word, and the other applications, so it is a generalized external function rather than an application-specific one. You'll note the the associated help refers to searching for text and never mentions numbers. Numbers in Excel are normally not text, which is why the search function cannot find them. However, it's possible to enter numbers as text in Excel, and those numbers should be searchable. In microsoft.public.office.misc Dima wrote: Thanks Gary Smith for your explanation! The Excel (Office) File search is not an external function. It is called up from the Excel File menu. Best regards, Dima "Gary Smith" wrote: The numbers you see when you view a spreadsheet in Excel are not the same as the data stored in the .xls file. No general search tool will be able to find such numbers unless is is capable of parsing the .xls file format and interpreting the contents. That's why you can search for numbers from withing Excel but not from an external function. In microsoft.public.office.misc Dima wrote: Thanks Bob I for your thought! There is no a "number in Excel", but only "text or property" in the Property list in the Advanced file search. Why does not the "text or property" search for a number in the Excel? How to find an Excel file with the number in its cell then? Best regards, Dima "Bob I" wrote: Perhaps the text that you are searching for and the "number in Excel" are not the same thing? They only appear similar to the user? Dima wrote: Thanks Bob I for your helping questions! Yes, the search criteria is being added to the "includes". It was working before partially. It did not find all files. I have tried Windows 2000 file search. It did not find the excel file by a number in its cell too. Best regards, Dima "Bob I" wrote: I am puzzled as to why it is not finding the file then. Have you tried several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 -- Gary L. Smith Columbus, Ohio -- Gary L. Smith Columbus, Ohio |
#13
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Thanks Gary Smith for your thought!
The file search function does find Excel files by numbers (not text) in them some times. Best regards, Dima "Gary Smith" wrote: Actually as I understand it, the file search function is a separate Office function that is invoked by Excel, Word, and the other applications, so it is a generalized external function rather than an application-specific one. You'll note the the associated help refers to searching for text and never mentions numbers. Numbers in Excel are normally not text, which is why the search function cannot find them. However, it's possible to enter numbers as text in Excel, and those numbers should be searchable. In microsoft.public.office.misc Dima wrote: Thanks Gary Smith for your explanation! The Excel (Office) File search is not an external function. It is called up from the Excel File menu. Best regards, Dima "Gary Smith" wrote: The numbers you see when you view a spreadsheet in Excel are not the same as the data stored in the .xls file. No general search tool will be able to find such numbers unless is is capable of parsing the .xls file format and interpreting the contents. That's why you can search for numbers from withing Excel but not from an external function. In microsoft.public.office.misc Dima wrote: Thanks Bob I for your thought! There is no a "number in Excel", but only "text or property" in the Property list in the Advanced file search. Why does not the "text or property" search for a number in the Excel? How to find an Excel file with the number in its cell then? Best regards, Dima "Bob I" wrote: Perhaps the text that you are searching for and the "number in Excel" are not the same thing? They only appear similar to the user? Dima wrote: Thanks Bob I for your helping questions! Yes, the search criteria is being added to the "includes". It was working before partially. It did not find all files. I have tried Windows 2000 file search. It did not find the excel file by a number in its cell too. Best regards, Dima "Bob I" wrote: I am puzzled as to why it is not finding the file then. Have you tried several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 -- Gary L. Smith Columbus, Ohio -- Gary L. Smith Columbus, Ohio |
#14
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Search WILL find a number in a cell in an Excel spreadsheet. The
question is what are you actually searching for, as compared to what you expect it to find. You have NOT given an example of this. So we will have to keep guessing until you discover what causes your search to not return what you expect. Excel will find many variations in the representation of a number. So the issue is something that your system is set to or configured to do that is causing the issue. Is it perhaps a protected file or cells? Dima wrote: Thanks Bob I for your thought! There is no a "number in Excel", but only "text or property" in the Property list in the Advanced file search. Why does not the "text or property" search for a number in the Excel? How to find an Excel file with the number in its cell then? Best regards, Dima "Bob I" wrote: Perhaps the text that you are searching for and the "number in Excel" are not the same thing? They only appear similar to the user? Dima wrote: Thanks Bob I for your helping questions! Yes, the search criteria is being added to the "includes". It was working before partially. It did not find all files. I have tried Windows 2000 file search. It did not find the excel file by a number in its cell too. Best regards, Dima "Bob I" wrote: I am puzzled as to why it is not finding the file then. Have you tried several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#15
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Thanks Bob I for your reply!
It is not a protected file or cells. Excel does not find any variations in the representation of my number. I search for the number, shown in a cell and in the formula bar. I type it in the "Value" field with the "Text or property" selected. I selected the file folder in the "Results should be" and the Excel file type in the "Search in". Best regards, Dima "Bob I" wrote: Search WILL find a number in a cell in an Excel spreadsheet. The question is what are you actually searching for, as compared to what you expect it to find. You have NOT given an example of this. So we will have to keep guessing until you discover what causes your search to not return what you expect. Excel will find many variations in the representation of a number. So the issue is something that your system is set to or configured to do that is causing the issue. Is it perhaps a protected file or cells? Dima wrote: Thanks Bob I for your thought! There is no a "number in Excel", but only "text or property" in the Property list in the Advanced file search. Why does not the "text or property" search for a number in the Excel? How to find an Excel file with the number in its cell then? Best regards, Dima "Bob I" wrote: Perhaps the text that you are searching for and the "number in Excel" are not the same thing? They only appear similar to the user? Dima wrote: Thanks Bob I for your helping questions! Yes, the search criteria is being added to the "includes". It was working before partially. It did not find all files. I have tried Windows 2000 file search. It did not find the excel file by a number in its cell too. Best regards, Dima "Bob I" wrote: I am puzzled as to why it is not finding the file then. Have you tried several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#16
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
You say it only works sometimes, compare the circumstances that work
with the one that does not work. What are the differences? Dima wrote: Thanks Bob I for your reply! It is not a protected file or cells. Excel does not find any variations in the representation of my number. I search for the number, shown in a cell and in the formula bar. I type it in the "Value" field with the "Text or property" selected. I selected the file folder in the "Results should be" and the Excel file type in the "Search in". Best regards, Dima "Bob I" wrote: Search WILL find a number in a cell in an Excel spreadsheet. The question is what are you actually searching for, as compared to what you expect it to find. You have NOT given an example of this. So we will have to keep guessing until you discover what causes your search to not return what you expect. Excel will find many variations in the representation of a number. So the issue is something that your system is set to or configured to do that is causing the issue. Is it perhaps a protected file or cells? Dima wrote: Thanks Bob I for your thought! There is no a "number in Excel", but only "text or property" in the Property list in the Advanced file search. Why does not the "text or property" search for a number in the Excel? How to find an Excel file with the number in its cell then? Best regards, Dima "Bob I" wrote: Perhaps the text that you are searching for and the "number in Excel" are not the same thing? They only appear similar to the user? Dima wrote: Thanks Bob I for your helping questions! Yes, the search criteria is being added to the "includes". It was working before partially. It did not find all files. I have tried Windows 2000 file search. It did not find the excel file by a number in its cell too. Best regards, Dima "Bob I" wrote: I am puzzled as to why it is not finding the file then. Have you tried several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#17
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
Thanks Bob I for your reply!
I cannot find any conceptual differences. Best regards, Dima "Bob I" wrote: You say it only works sometimes, compare the circumstances that work with the one that does not work. What are the differences? Dima wrote: Thanks Bob I for your reply! It is not a protected file or cells. Excel does not find any variations in the representation of my number. I search for the number, shown in a cell and in the formula bar. I type it in the "Value" field with the "Text or property" selected. I selected the file folder in the "Results should be" and the Excel file type in the "Search in". Best regards, Dima "Bob I" wrote: Search WILL find a number in a cell in an Excel spreadsheet. The question is what are you actually searching for, as compared to what you expect it to find. You have NOT given an example of this. So we will have to keep guessing until you discover what causes your search to not return what you expect. Excel will find many variations in the representation of a number. So the issue is something that your system is set to or configured to do that is causing the issue. Is it perhaps a protected file or cells? Dima wrote: Thanks Bob I for your thought! There is no a "number in Excel", but only "text or property" in the Property list in the Advanced file search. Why does not the "text or property" search for a number in the Excel? How to find an Excel file with the number in its cell then? Best regards, Dima "Bob I" wrote: Perhaps the text that you are searching for and the "number in Excel" are not the same thing? They only appear similar to the user? Dima wrote: Thanks Bob I for your helping questions! Yes, the search criteria is being added to the "includes". It was working before partially. It did not find all files. I have tried Windows 2000 file search. It did not find the excel file by a number in its cell too. Best regards, Dima "Bob I" wrote: I am puzzled as to why it is not finding the file then. Have you tried several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
#18
![]()
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
![]()
I'm sorry.
Dima wrote: Thanks Bob I for your reply! I cannot find any conceptual differences. Best regards, Dima "Bob I" wrote: You say it only works sometimes, compare the circumstances that work with the one that does not work. What are the differences? Dima wrote: Thanks Bob I for your reply! It is not a protected file or cells. Excel does not find any variations in the representation of my number. I search for the number, shown in a cell and in the formula bar. I type it in the "Value" field with the "Text or property" selected. I selected the file folder in the "Results should be" and the Excel file type in the "Search in". Best regards, Dima "Bob I" wrote: Search WILL find a number in a cell in an Excel spreadsheet. The question is what are you actually searching for, as compared to what you expect it to find. You have NOT given an example of this. So we will have to keep guessing until you discover what causes your search to not return what you expect. Excel will find many variations in the representation of a number. So the issue is something that your system is set to or configured to do that is causing the issue. Is it perhaps a protected file or cells? Dima wrote: Thanks Bob I for your thought! There is no a "number in Excel", but only "text or property" in the Property list in the Advanced file search. Why does not the "text or property" search for a number in the Excel? How to find an Excel file with the number in its cell then? Best regards, Dima "Bob I" wrote: Perhaps the text that you are searching for and the "number in Excel" are not the same thing? They only appear similar to the user? Dima wrote: Thanks Bob I for your helping questions! Yes, the search criteria is being added to the "includes". It was working before partially. It did not find all files. I have tried Windows 2000 file search. It did not find the excel file by a number in its cell too. Best regards, Dima "Bob I" wrote: I am puzzled as to why it is not finding the file then. Have you tried several different searches? Is the search criteria being added to the "includes"? Was it working before? Dima wrote: Thanks Bob I for your questions! Yes, the Location is actually accessible, in NOT a hidden or system folder. I can browse to those files and open them. "Bob I" wrote: Is the Location actually accessible? As in NOT a hidden or system folder? Dima wrote: Thanks Bob I for replying. That goes without saying. I set file types and Search Location also. Best regards, Dima "Bob I" wrote: You need to Set file types and Search Location also. Dima wrote: Hello! How to make the Office 2003 Advanced file search to find files by the "text or property"? The Office 2003 sp2 Advanced file search does not find a Word or Excel file by a word or a number in an excel cell. Best regards, Dima +79035093892 |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening files with "last modified" or "text or property" options | Microsoft Word Help | |||
The search "Find Next" with "wildcards" does not function properly | Microsoft Word Help | |||
"find" and "search/replace" modes | Microsoft Word Help | |||
files I want to "save as" are all showing "file permission error" | Microsoft Word Help | |||
To be able to jump by style (like "Find Next" in "Search") | Microsoft Word Help |