I have a master document of construction data that updates itself
whenever I put a number like "124" in d5 (field)
I want to add a picture from a folder of digital images that are named
sequentially like:  dsc00124.jpg

I have a user created in Active Directory and logging into an XP Pro PC and
using Excel XP. He created an Excel 97 spreadsheet with active links to
other Excel spreadsheets when he was on NT. In Office 97 the link was
created with specifically a drive letter of H: to the location of ...

Oddly enough I was going to just post a question about bringing in a new
picture depending on what doc I was in, and lo-n-behold, the answer may be
very similar to Joe Williams.  
I'll make this very generic.  :-)   I have one multi-sheet Excel file with a

Hi...  simple problem.
I have made a spreadsheet that employees will fill out.  There is one per
customer job.  I have attempted to make one workbook that will link to all
the others so i can monitor the status' of the job spreadsheet.

I have 10 or so links from File1 used in File2.  When both files are
open everything works well.
However, when File1 is closed and I open File2 I get the error:
 "The workbook contains one or more links..." and does not update.

I want to do a very simple task - click on a link in one worksheet and get it
to open a specific tab in another worksheet.  Is this possible?

Recently the IT dept just changed the laptop for our F&A Manager. When he
opens the Excel files, the links in the all cells are changed to this
folder:
"'C:\Documents and Settings\neilm\Application

Is there a way to make a hyperlink directly to the chart tab in excel?
Appreciate any help.
Thanks.....Aloys

Can I link data in Access to a spreadsheet?  Use Access & Excel 2003.
Thanks!

      Could anybody recomend me a link to learn EXCEL from a beginner to
using all functions.
With regards,
SMART.

Is it possible to write a macro which will open all linked workbooks
without hard coding the workbook names so as to make such a macro more
general?
Thanks

I have a link set up froma cell on worksheet one to worksheet two.  There are
several links on worksheet one to access worksheets 2-15.  If the cell is
changed (one WS 1), I would like the name of the worksheet to change too (on
any of the WS 2-15). I can get the worksheet name  and ...

I have problem with VBA for EXCEL. In formulas there are links to other
files . When it's open it normally connects with other files and everything
is OK, but the other files are open protected with a password, so each time
I have to put the password manually. There are MANY files ...

I am trying to solve a "simple" problem:
There are various links in an Excel sheet - all point to an Extranet where a
login is required. In order to avoid multiple logins when clicking several
links in the Excel file, all links in the Excel sheet should reference the

Is there any way to change a field to a blank when a link cannot be
updated?
I have a series of worksheets that pull their information from other
excel spreadsheets in a directory. When there aren't any files in that