I need to know which excel workbooks are linked to an excel file that I want
to make changes to in order to avoid creating incorrect references once I
make the change.  Is there a way to list all other excel files that are
linked to the excel file I want to alter?

I need 20 of my staff to be able to access and update a spreadsheet in
realtime, all at the same time. Is this possible? What I am doing is
generating call lists of existing clients hundreds of lines long, and I want
my staff to open up the spreadsheet and start calling those ...

In cell A this is the formula  :
          BUYER_LAST_NAME                            BUYER_FIRST_NAME      
                                    BUYER_FIRST_LAST_NAME                    
                                           BUYER_STREET1                    

I have two tables. Both have headers across the top and down the left side.
What I need to do is fill in the second table by matching the info in its
headers with those in the first table and pulling the data at the juncture.
What is your recommendation on the best way to accomplish ...

I need to calculate compounding interest.  Example I have an account that had
a balance of 40,000 in FY02.  The account now has 72,000 at the end of FY07.  
I need to calculated what the compounded interest rate was for the time
between 02 and 07.

I have two spreadsheets.  Both spreadsheets have Material listed in Column A.
Spreadsheet 2 has a value in Column H that needs to be carried over to
Column H of Spreadsheet 1.  The Material list in Spreadsheet 2 is only a
partial listing of the Material in Spreadsheet 1.  How do ...

I have looked every where to purchase this software and can not find it in
the stores any where..... Why is it so high priced on the web site when all
the newer software is the same price but the older version is a better
product?

Why do I get an error:
Sht = Sheets("print").Range("D" & a).Value
       Sheets(Sht).Range("Print_Area" & Sht).Select
but when I cut it in 2 it works:

I having never had problems sorting in Excel 2007 until today.  I have an
excel spreadsheet with headers and I select the whole worksheet and go
data/sort.  I then choose the header I want to use to sort and sort it from A
to Z.  In this case it is by company name.  When I hit ...

I have some spreadsheets with numbers values I have entered manually (for
example a price list for certain products) going into the new year I want to
increase all prices by a certain percent. Just wondering if there is an easy
way to change all the numbers at once and not one at ...

This is a really annoying problem: I have a worksheet with a macro I
wrote to do some reformatting on one of the sheets before I submit it as
a CSV file to a database. I set up a button on the toolbar linked to the
macro: when I open the file, move my data to this one sheet and ...

i converted my 2003 pmw ok and thought i loaded it into the correct
directory.  i added macro buttons to the customized toolbar and used them.  
then a month ago excel seemed to go brain dead and couldn't find the pmw
anymore.  so i manually load it now.  but it will not run any ...

Is anyone aware of functionality in Excel 2003 that allows you to create a
drop down list of values in a cell to choose from for entering data?  Similar
to the autocomplete functionality- but an actual drop down arrow on the cell
that allows you to point and click on the text you ...

THere is a setting that indicates how many rows are returned when the filter
function is used. How do I turn that setting on ?

I have about 11,000 documents listed in a worksheet that are individually
numbered, and want find duplicate entries in the worksheet. I need to create
a formula that will allow me to see ONLY the duplicates.