I am working in one workbook:  
Sheet1 is the Master of approx 50 columns by 1400 rows.  That data is
refreshed daily from a .txt file.  The sheet normally increases in the number
of rows by anywhere from 1 to 100+ rows per day.  The columns do not change.

I'm trying to link a sheet from one workbook to a sheet in another workbook,
and to update the info when it's changed on a daily basis...can anyone
help....have not been able to find out how to do this with the research I've
done...Thanks

   Could anybody recomend me a good book to learn EXCEL from a beginner to
using all functions
Tom G.

I have a spreadsheet with a bank of index buttons at the top that are linked
to separate series of data blocks listed below.  The panes are frozen right
below the index buttons.
I have linked the top index buttons to a cell at the top of the appropriate

I have 6 excel files which are to be opened in a sequence. Any help regarding
writing a macro to do that?

I created a link using the "create hyperlink" button.  This links to a
directory on my drive.  I test the link and it works.  The instant I save the
file, the link breaks and no longer works.  Editing the link shows that excel
has changed the link into something cryptic.  It ...

Can anyone advise me on this?
I have a 3 x 3 matrix with columns A,B,C and rows 1,2,3.  Each cell contains
a simple link such as (=J6) but all 9 links are different.  I write down a 9
x 2 matrix  A1,B1,C1,A2,B2,C2,A3,B3,C3 in the first column with the values

It seems I have email addresses in my spreadsheet that have lost their
ability to hyperlink.  How do I get back?

I have a workbook with many named cells.  A second workbook has links
back to the first workbook.  When I open the second workbook via an UNC
path, rather than a named drive letter, the link changes to a different
named cell of the first workbook.

I am trying complex linking project and was anyone knowledgeable to help
me....this is the situation....
I have 4 workbooks that I want to link to a 5th workbook to update the
sheets on that 5th workbook...here's where the difficult part comes in....

I have two columns, A and B. Column A has names. Column B has prices
that are VLOOKUPed from a closed file (based on the names in Column A).
The problem is that the file from which I am pulling in prices is
generated daily.

Can anyone help me with this request?
I can copy the data in cell D4 of worksheet 'Sheet1' to,say, cell E5 in
Sheet2 in the same workbook by typing into Sheet2,cell E5 " =sheet1!D4 ".
Is it possible to refer to another cell in Sheet2 which contains the cell

How do I update SQL Server database through Excel? Can it be done?

I have a need to automatically save the current date to a cell in an excel spreadsheet every time the sheet is saved.
Today() always returns the current date, so once I open the sheet on a new day I can no longer see the date the information was last updated, i.e. saved.
Any help ...

How can i make in excel link to a picture, but i need to open it in excel,
not other graphic program.
For example, i have list of people, and i need to show their photos, when i
click on first person i see its picture, second i see second picture but in