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 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 ...

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

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