We have about a dozen XP machines with Office 2003 installed. All but one of
these machines executes our Excel applications without error. One of these
machines produces run time prompts and errors that do not occur on any other
machine. I have checked Options and References. We just reinstalled Office.
The physical machines are the same. All are updated automatically from a
network. All are in a highly secure environment with no connection to the
internet.

I have identified one area as different on the errant machine. This machine
requires that ranges be fully qualified where lesser qualification is fine on
all the others. For example on all other machines the following works:
Range("SheetName!RangeName").Value
On the errant machine I have to use:
Range("'[WorkBookName.xls]SheetName'!RangeName").Value
Also in VBA code, when the workbook in which the range name exists is
active, I can use the shorter version as shown above. But on the errant
machine I must use:
Workbooks("WorkBookName.xls").Worksheets("WorkShee tName").Range("'[WorkBookName.xls]SheetName'!RangeName").Value

Also, on the errant machine when I create a new worksheet from a template,
Excel prompts for a choice to update references and on all other machines
this prompt does not occur.

What could be different on the errant machine? Should we have the network
admin replace the errant machine?

--
Pictou