Excel Option/Reference/Install/Environment/etc. Issue

[Steve McLeod]

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("WorkSheetName").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?

 

[Joel]

Check the XLSTART directory on the bad machine to see if there are any files
in this directory. Also check if the probelm occurs with more than one user
logged in. There may be some registry differences and it would help to find
out if these differences are against all users or just one user.

 

[Steve McLeod]

Checked XLSTART. Both System and User. All empty on all machines.
None of use can do anything that writes to the register so by definition it
must be the same.
All users have the same issues.
These were good suggestions, but do not seem to hold an answer.

--
Pictou

Check the XLSTART directory on the bad machine to see if there are any files
in this directory. Also check if the probelm occurs with more than one user
logged in. There may be some registry differences and it would help to find
out if these differences are against all users or just one user.

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("WorkSheetName").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?

 

[Joel]

You may also want to check the version of excel installed by going to Help -
About.

You are wrong about the registry entries. In window you must allow the
users to write to the registry. Things like the RECENTLY USED FILES are in
the registry. User Registry items can be changed. Also administrators do
have access to registry setttings. Re-Installing software doesn't always
reset the registry settings.


Check registry entries under

HKEY_CLASSES_ROOT
HKEY_CURRENT_USER
HKEY_LOCAL_MACHINE
HKEY_USERS
HKEY_CURRENT_CONFIG


............. Software\Microsoft\Offfice\11.0\Excel

Checked XLSTART. Both System and User. All empty on all machines.
None of use can do anything that writes to the register so by definition it
must be the same.
All users have the same issues.
These were good suggestions, but do not seem to hold an answer.

--
Pictou

Check the XLSTART directory on the bad machine to see if there are any files
in this directory. Also check if the probelm occurs with more than one user
logged in. There may be some registry differences and it would help to find
out if these differences are against all users or just one user.

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("WorkSheetName").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?

 

[JLGWhiz]

Hi Joel, it is not advisable for someone who has not been trained in
modifying the registry to attempt to make changes, even if they can access
it. There are certain precise actions that need to be taken in making
registry changes. But, if someone in the office has Administrator
priviledges, then they could at least look to see if there are differences in
the entries.

You may also want to check the version of excel installed by going to Help -
About.

You are wrong about the registry entries. In window you must allow the
users to write to the registry. Things like the RECENTLY USED FILES are in
the registry. User Registry items can be changed. Also administrators do
have access to registry setttings. Re-Installing software doesn't always
reset the registry settings.


Check registry entries under

HKEY_CLASSES_ROOT
HKEY_CURRENT_USER
HKEY_LOCAL_MACHINE
HKEY_USERS
HKEY_CURRENT_CONFIG


............ Software\Microsoft\Offfice\11.0\Excel

Checked XLSTART. Both System and User. All empty on all machines.
None of use can do anything that writes to the register so by definition it
must be the same.
All users have the same issues.
These were good suggestions, but do not seem to hold an answer.

--
Pictou

Check the XLSTART directory on the bad machine to see if there are any files
in this directory. Also check if the probelm occurs with more than one user
logged in. There may be some registry differences and it would help to find
out if these differences are against all users or just one user.

:

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("WorkSheetName").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?

 

[JLGWhiz]

Steve, you said you had checked the Options settings in Excel, but did you
check them in VBA? In VBA>Options>Editor, it the Require Variables
Declarations block is checked, you would have to fully declare all variables,
even if Option Explicit is not declared in the code module.

Checked XLSTART. Both System and User. All empty on all machines.
None of use can do anything that writes to the register so by definition it
must be the same.
All users have the same issues.
These were good suggestions, but do not seem to hold an answer.

--
Pictou

Check the XLSTART directory on the bad machine to see if there are any files
in this directory. Also check if the probelm occurs with more than one user
logged in. There may be some registry differences and it would help to find
out if these differences are against all users or just one user.

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("WorkSheetName").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?