I would appreciate receiving a link to download the practice files
accompanying the above book by Frye.
thank you
yuval :)

Good evenin
I need to automatically change the value in a cell once i select a value in
another cell.
For example, if  i have 3 values: a,b,c (using a drop down list in C1) and

I have a workbook with 12 worksheets or tabs say Tab1, Tab2...Tab12  in it,
each dedicated to one of 12 employees respectively to say Emp1, Emp2,..Emp12.
The requirement is to set up protection such that Emp1 can read only Tab1
(other tabs should be either greyed out or not ...

I have an Excel spreadsheet with a macro. What I want to do is to be able to
start this spreadsheet via a BAT file(mainly to schedule the running). But
the kicker is to run the Macro. I realize I may have to disable the security
to get passed the ENABLE/DISABLE prompt..or is ...

I'm working with an excel spreadsheet (duh, or else I wouldn't be here).
I've set up a few hyperlkinks to related files. However when I click on the
hyperlink it opens the directrory in explorer and not the actual file. I'm
using excel 2000 if that helps anything. Anyone have any ...

Let's say I have a test matrix that has the following columns:
TC_NAME, REQ#, TESTER, AUTOMATE
In the TC_NAME are the test cases where the TCs appear multiple times
when they address multiple requirements.

I have created a page of hyperlinks to other worksheets in a workbook.
On just one of them, when I click the hyperlink cell, it sends me to
the right page but the entire page is highlighted. When I try to
re-setup the hyperlink, I can set the worksheet again OK but the

This is probably an easy question to most. I am hosting a tournament an
need to be able to enter all scores and then have it give me 1st, 2n
3rd etc. Can anyone help? I have fill out all the names, can get th
sum function to give total but not in order of name and score.

I have a spreadsheet with cells that are created by calculating values on
another spreadsheet.  I'd like to send this worksheet to a client, who won't
have access to the referenced spreadsheets.  How can I change the properties
of the cells such that they become "static"?

I get an error (#DIV/0!) when I divide one cell by the other and there are
no entries in the cells.
How can i get the folrmula to surpress the error (show a blank cell) when
there are no entries in the cells that the formula refers to?

I am newbie here and is having hard time in doing this.
I have an excel workbook which has two sheets Grp1 and Grp2
within these sheets i have unit and id columns, what I am trying to d
is find out the combination of unit and id column which is on Grp1 bu

One of our clients has a Peer-To-Peer environment with one of the peer
computer hosting all of the shared folders.
When the other peers try to browse to the shares using the "Look in:" option
(within Word and Excel) to open a word document or excel spreadsheet it

Excel2003
WindowsXP
I know I saw the answer in this forum before.
I have an Excel spreadsheet. The cells have formulas in them. You only see

For instance, A1 = 8:20, B1 = 16:30.
I need to compute in C1 the following: B1 - A1 - 0.5 hour.
What is the formula?
If I use formula B1 - A1 - 0:30 I get invalid value.

I have a CSV/Txt file that I am opening and I tell it that it is tab
delimited.
I find that my first columns, that have numbers in them, are dropping the
leading 0's.  I don't want that.  I need the leading zeros.