My boss has saved a lot of workbooks on his desktop€”mostly budget scenarios
and financial statements. He prints out and saves hard copies, then he
forgets where the electronic file has been stored. I have tried to use the
Search feature in Windows Explorer to find a source worksheet from the hard
copy. I look for a unique number on the worksheet€”say the grand total, which
is unlikely to be duplicated on any other worksheet€”and then use the F3
Search feature in Windows Explorer to find this file. "Search for files or
folders named" = *.xls ; "Containing" = $222,321.19 (i.e. the grand total)
and I search through all of the files on his desktop.

Sometimes the search will return a list of files, sometimes not. It must
depend upon the format of the number. Has anyone ever used this technique,
or does anyone have a tip they could share? My boss is pretty set in his
ways, so I am looking for a way to solve the problem he has created, not to
change his ways. Thanks for your help!


Bill Wilson

Numbers are not stored in Excel in the way that we see them, so you
can't search for them reliably. If you set up the sheet to print the
date and time as a header or footer, and if your boss saves the file
after printing, then it might be more fruitful to do a search by date
saved.

Hope this helps.

Pete

On Nov 16, 10:59 pm, Bill Wilson .
(donotspam) wrote:
My boss has saved a lot of workbooks on his desktop--mostly budget scenarios
and financial statements. He prints out and saves hard copies, then he
forgets where the electronic file has been stored. I have tried to use the
Search feature in Windows Explorer to find a source worksheet from the hard
copy. I look for a unique number on the worksheet--say the grand total, which
is unlikely to be duplicated on any other worksheet--and then use the F3
Search feature in Windows Explorer to find this file. "Search for files or
folders named" = *.xls ; "Containing" = $222,321.19 (i.e. the grand total)
and I search through all of the files on his desktop.

Sometimes the search will return a list of files, sometimes not. It must
depend upon the format of the number. Has anyone ever used this technique,
or does anyone have a tip they could share? My boss is pretty set in his
ways, so I am looking for a way to solve the problem he has created, not to
change his ways. Thanks for your help!

Bill Wilson

do the search in the Excel- File/Open/Tools/Find window

"Pete_UK" wrote:

Numbers are not stored in Excel in the way that we see them, so you
can't search for them reliably. If you set up the sheet to print the
date and time as a header or footer, and if your boss saves the file
after printing, then it might be more fruitful to do a search by date
saved.

Hope this helps.

Pete

On Nov 16, 10:59 pm, Bill Wilson .
(donotspam) wrote:
My boss has saved a lot of workbooks on his desktop--mostly budget scenarios
and financial statements. He prints out and saves hard copies, then he
forgets where the electronic file has been stored. I have tried to use the
Search feature in Windows Explorer to find a source worksheet from the hard
copy. I look for a unique number on the worksheet--say the grand total, which
is unlikely to be duplicated on any other worksheet--and then use the F3
Search feature in Windows Explorer to find this file. "Search for files or
folders named" = *.xls ; "Containing" = $222,321.19 (i.e. the grand total)
and I search through all of the files on his desktop.

Sometimes the search will return a list of files, sometimes not. It must
depend upon the format of the number. Has anyone ever used this technique,
or does anyone have a tip they could share? My boss is pretty set in his
ways, so I am looking for a way to solve the problem he has created, not to
change his ways. Thanks for your help!

Bill Wilson

The OP is looking for a file - if he knew which one it was then he
would use File | Open.

I'm not aware of any Find on the Tools menu.

Pete

On Nov 17, 6:01 pm, dlw wrote:
do the search in the Excel- File/Open/Tools/Find window



"Pete_UK" wrote:
Numbers are not stored in Excel in the way that we see them, so you
can't search for them reliably. If you set up the sheet to print the
date and time as a header or footer, and if your boss saves the file
after printing, then it might be more fruitful to do a search by date
saved.

Hope this helps.

Pete

On Nov 16, 10:59 pm, Bill Wilson .
(donotspam) wrote:
My boss has saved a lot of workbooks on his desktop--mostly budget scenarios
and financial statements. He prints out and saves hard copies, then he
forgets where the electronic file has been stored. I have tried to use the
Search feature in Windows Explorer to find a source worksheet from the hard
copy. I look for a unique number on the worksheet--say the grand total, which
is unlikely to be duplicated on any other worksheet--and then use the F3
Search feature in Windows Explorer to find this file. "Search for files or
folders named" = *.xls ; "Containing" = $222,321.19 (i.e. the grand total)
and I search through all of the files on his desktop.

Sometimes the search will return a list of files, sometimes not. It must
depend upon the format of the number. Has anyone ever used this technique,
or does anyone have a tip they could share? My boss is pretty set in his
ways, so I am looking for a way to solve the problem he has created, not to
change his ways. Thanks for your help!

Bill Wilson- Hide quoted text -

- Show quoted text -

In xl2003, there's:

File|Open|Tools|Search
(not the Tools option from the excel's worksheet menubar)

Pete_UK wrote:

The OP is looking for a file - if he knew which one it was then he
would use File | Open.

I'm not aware of any Find on the Tools menu.

Pete

On Nov 17, 6:01 pm, dlw wrote:
do the search in the Excel- File/Open/Tools/Find window



"Pete_UK" wrote:
Numbers are not stored in Excel in the way that we see them, so you
can't search for them reliably. If you set up the sheet to print the
date and time as a header or footer, and if your boss saves the file
after printing, then it might be more fruitful to do a search by date
saved.

Hope this helps.

Pete

On Nov 16, 10:59 pm, Bill Wilson .
(donotspam) wrote:
My boss has saved a lot of workbooks on his desktop--mostly budget scenarios
and financial statements. He prints out and saves hard copies, then he
forgets where the electronic file has been stored. I have tried to use the
Search feature in Windows Explorer to find a source worksheet from the hard
copy. I look for a unique number on the worksheet--say the grand total, which
is unlikely to be duplicated on any other worksheet--and then use the F3
Search feature in Windows Explorer to find this file. "Search for files or
folders named" = *.xls ; "Containing" = $222,321.19 (i.e. the grand total)
and I search through all of the files on his desktop.

Sometimes the search will return a list of files, sometimes not. It must
depend upon the format of the number. Has anyone ever used this technique,
or does anyone have a tip they could share? My boss is pretty set in his
ways, so I am looking for a way to solve the problem he has created, not to
change his ways. Thanks for your help!

Bill Wilson- Hide quoted text -

- Show quoted text -

--

Dave Peterson

It's not there in XL 2000, Dave.

Pete

On Nov 17, 8:34 pm, Dave Peterson wrote:
In xl2003, there's:

File|Open|Tools|Search
(not the Tools option from the excel's worksheet menubar)





Pete_UK wrote:

The OP is looking for a file - if he knew which one it was then he
would use File | Open.

I'm not aware of any Find on the Tools menu.

Pete

On Nov 17, 6:01 pm, dlw wrote:
do the search in the Excel- File/Open/Tools/Find window

"Pete_UK" wrote:
Numbers are not stored in Excel in the way that we see them, so you
can't search for them reliably. If you set up the sheet to print the
date and time as a header or footer, and if your boss saves the file
after printing, then it might be more fruitful to do a search by date
saved.

Hope this helps.

Pete

On Nov 16, 10:59 pm, Bill Wilson .
(donotspam) wrote:
My boss has saved a lot of workbooks on his desktop--mostly budget scenarios
and financial statements. He prints out and saves hard copies, then he
forgets where the electronic file has been stored. I have tried to use the
Search feature in Windows Explorer to find a source worksheet from the hard
copy. I look for a unique number on the worksheet--say the grand total, which
is unlikely to be duplicated on any other worksheet--and then use the F3
Search feature in Windows Explorer to find this file. "Search for files or
folders named" = *.xls ; "Containing" = $222,321.19 (i.e. the grand total)
and I search through all of the files on his desktop.

Sometimes the search will return a list of files, sometimes not. It must
depend upon the format of the number. Has anyone ever used this technique,
or does anyone have a tip they could share? My boss is pretty set in his
ways, so I am looking for a way to solve the problem he has created, not to
change his ways. Thanks for your help!

Bill Wilson- Hide quoted text -

- Show quoted text -

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Sorry, yes it is - you have to know it's there !!

Pete

On Nov 17, 8:40 pm, Pete_UK wrote:
It's not there in XL 2000, Dave.

Pete

On Nov 17, 8:34 pm, Dave Peterson wrote:



In xl2003, there's:

File|Open|Tools|Search
(not the Tools option from the excel's worksheet menubar)

Pete_UK wrote:

The OP is looking for a file - if he knew which one it was then he
would use File | Open.

I'm not aware of any Find on the Tools menu.

Pete

On Nov 17, 6:01 pm, dlw wrote:
do the search in the Excel- File/Open/Tools/Find window

"Pete_UK" wrote:
Numbers are not stored in Excel in the way that we see them, so you
can't search for them reliably. If you set up the sheet to print the
date and time as a header or footer, and if your boss saves the file
after printing, then it might be more fruitful to do a search by date
saved.

Hope this helps.

Pete

On Nov 16, 10:59 pm, Bill Wilson .
(donotspam) wrote:
My boss has saved a lot of workbooks on his desktop--mostly budget scenarios
and financial statements. He prints out and saves hard copies, then he
forgets where the electronic file has been stored. I have tried to use the
Search feature in Windows Explorer to find a source worksheet from the hard
copy. I look for a unique number on the worksheet--say the grand total, which
is unlikely to be duplicated on any other worksheet--and then use the F3
Search feature in Windows Explorer to find this file. "Search for files or
folders named" = *.xls ; "Containing" = $222,321.19 (i.e. the grand total)
and I search through all of the files on his desktop.

Sometimes the search will return a list of files, sometimes not. It must
depend upon the format of the number. Has anyone ever used this technique,
or does anyone have a tip they could share? My boss is pretty set in his
ways, so I am looking for a way to solve the problem he has created, not to
change his ways. Thanks for your help!

Bill Wilson- Hide quoted text -

- Show quoted text -

--

Dave Peterson- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

It's been a long time since I used xl2k. (I trust your answer <vbg.)

Pete_UK wrote:

It's not there in XL 2000, Dave.

Pete

On Nov 17, 8:34 pm, Dave Peterson wrote:
In xl2003, there's:

File|Open|Tools|Search
(not the Tools option from the excel's worksheet menubar)





Pete_UK wrote:

The OP is looking for a file - if he knew which one it was then he
would use File | Open.

I'm not aware of any Find on the Tools menu.

Pete

On Nov 17, 6:01 pm, dlw wrote:
do the search in the Excel- File/Open/Tools/Find window

"Pete_UK" wrote:
Numbers are not stored in Excel in the way that we see them, so you
can't search for them reliably. If you set up the sheet to print the
date and time as a header or footer, and if your boss saves the file
after printing, then it might be more fruitful to do a search by date
saved.

Hope this helps.

Pete

On Nov 16, 10:59 pm, Bill Wilson .
(donotspam) wrote:
My boss has saved a lot of workbooks on his desktop--mostly budget scenarios
and financial statements. He prints out and saves hard copies, then he
forgets where the electronic file has been stored. I have tried to use the
Search feature in Windows Explorer to find a source worksheet from the hard
copy. I look for a unique number on the worksheet--say the grand total, which
is unlikely to be duplicated on any other worksheet--and then use the F3
Search feature in Windows Explorer to find this file. "Search for files or
folders named" = *.xls ; "Containing" = $222,321.19 (i.e. the grand total)
and I search through all of the files on his desktop.

Sometimes the search will return a list of files, sometimes not. It must
depend upon the format of the number. Has anyone ever used this technique,
or does anyone have a tip they could share? My boss is pretty set in his
ways, so I am looking for a way to solve the problem he has created, not to
change his ways. Thanks for your help!

Bill Wilson- Hide quoted text -

- Show quoted text -

--

Dave Peterson- Hide quoted text -

- Show quoted text -

--

Dave Peterson

I shouldn't have trusted you!!!!

Dave Peterson wrote:

It's been a long time since I used xl2k. (I trust your answer <vbg.)

Pete_UK wrote:

It's not there in XL 2000, Dave.

Pete

On Nov 17, 8:34 pm, Dave Peterson wrote:
In xl2003, there's:

File|Open|Tools|Search
(not the Tools option from the excel's worksheet menubar)





Pete_UK wrote:

The OP is looking for a file - if he knew which one it was then he
would use File | Open.

I'm not aware of any Find on the Tools menu.

Pete

On Nov 17, 6:01 pm, dlw wrote:
do the search in the Excel- File/Open/Tools/Find window

"Pete_UK" wrote:
Numbers are not stored in Excel in the way that we see them, so you
can't search for them reliably. If you set up the sheet to print the
date and time as a header or footer, and if your boss saves the file
after printing, then it might be more fruitful to do a search by date
saved.

Hope this helps.

Pete

On Nov 16, 10:59 pm, Bill Wilson .
(donotspam) wrote:
My boss has saved a lot of workbooks on his desktop--mostly budget scenarios
and financial statements. He prints out and saves hard copies, then he
forgets where the electronic file has been stored. I have tried to use the
Search feature in Windows Explorer to find a source worksheet from the hard
copy. I look for a unique number on the worksheet--say the grand total, which
is unlikely to be duplicated on any other worksheet--and then use the F3
Search feature in Windows Explorer to find this file. "Search for files or
folders named" = *.xls ; "Containing" = $222,321.19 (i.e. the grand total)
and I search through all of the files on his desktop.

Sometimes the search will return a list of files, sometimes not. It must
depend upon the format of the number. Has anyone ever used this technique,
or does anyone have a tip they could share? My boss is pretty set in his
ways, so I am looking for a way to solve the problem he has created, not to
change his ways. Thanks for your help!

Bill Wilson- Hide quoted text -

- Show quoted text -

--

Dave Peterson- Hide quoted text -

- Show quoted text -

--

Dave Peterson

--

Dave Peterson

Just keeping you on your toes !! <bg

Pete

On Nov 17, 8:54 pm, Dave Peterson wrote:
I shouldn't have trusted you!!!!





Dave Peterson wrote:

It's been a long time since I used xl2k. (I trust your answer <vbg.)

Pete_UK wrote:

It's not there in XL 2000, Dave.

Pete

On Nov 17, 8:34 pm, Dave Peterson wrote:
In xl2003, there's:

File|Open|Tools|Search
(not the Tools option from the excel's worksheet menubar)

Pete_UK wrote:

The OP is looking for a file - if he knew which one it was then he
would use File | Open.

I'm not aware of any Find on the Tools menu.

Pete

On Nov 17, 6:01 pm, dlw wrote:
do the search in the Excel- File/Open/Tools/Find window

"Pete_UK" wrote:
Numbers are not stored in Excel in the way that we see them, so you
can't search for them reliably. If you set up the sheet to print the
date and time as a header or footer, and if your boss saves the file
after printing, then it might be more fruitful to do a search by date
saved.

Hope this helps.

Pete

On Nov 16, 10:59 pm, Bill Wilson .
(donotspam) wrote:
My boss has saved a lot of workbooks on his desktop--mostly budget scenarios
and financial statements. He prints out and saves hard copies, then he
forgets where the electronic file has been stored. I have tried to use the
Search feature in Windows Explorer to find a source worksheet from the hard
copy. I look for a unique number on the worksheet--say the grand total, which
is unlikely to be duplicated on any other worksheet--and then use the F3
Search feature in Windows Explorer to find this file. "Search for files or
folders named" = *.xls ; "Containing" = $222,321.19 (i.e. the grand total)
and I search through all of the files on his desktop.

Sometimes the search will return a list of files, sometimes not. It must
depend upon the format of the number. Has anyone ever used this technique,
or does anyone have a tip they could share? My boss is pretty set in his
ways, so I am looking for a way to solve the problem he has created, not to
change his ways. Thanks for your help!

Bill Wilson- Hide quoted text -

- Show quoted text -

--

Dave Peterson- Hide quoted text -

- Show quoted text -

--

Dave Peterson

--

Dave Peterson- Hide quoted text -

- Show quoted text -