Ok here it goes, I am currently working with an Excell sheet that is sent to
me daily with updated values and I am running a macro over this sheet in
Windows NT! There the macro works fine but when i try to reprogram the
procedure into Windows XP it wont work. I have by now figured out the reason
for this: The file that is sent to me has several formulars on cells, that
are not defined on my machine therefor if i open the excell sheet in XP it
will enter "#NAME?" into the concerning cells. On NT however it doesnt do so,
as it does not seem to execute the formulars on load, but simply keeps the
values with which the file was last saved.
Ok, so what i need to know is, can i somehow in VB or in some hidden
properties, tell Exel not to execute the formulars but keep the old values in
place??
Beware i dont mean links or tables or webquieries of any kind just formulars
in the cells.
I have also thought about a workaround already which is ok but not ideal, as
i could simply save the exel file as a text file on the NT machine and then
work with that textfile in XP, it does not help me getting away from NT
though.

Thanks a million for any suggestions

This has nothing to do with Windows versions but with what Excel files are
stored on the two PCs.
The NAME error indicates a reference to a function that is not present.
What does the formula in that cell read? You need to look for something like
=Personal.xls.SOMEFUNCTION(argument). The you need to copy that file (or the
functions in it) from the NT machine to the second PC
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kataklist" wrote in message
...
Ok here it goes, I am currently working with an Excell sheet that is sent
to
me daily with updated values and I am running a macro over this sheet in
Windows NT! There the macro works fine but when i try to reprogram the
procedure into Windows XP it wont work. I have by now figured out the
reason
for this: The file that is sent to me has several formulars on cells, that
are not defined on my machine therefor if i open the excell sheet in XP it
will enter "#NAME?" into the concerning cells. On NT however it doesnt do
so,
as it does not seem to execute the formulars on load, but simply keeps the
values with which the file was last saved.
Ok, so what i need to know is, can i somehow in VB or in some hidden
properties, tell Exel not to execute the formulars but keep the old values
in
place??
Beware i dont mean links or tables or webquieries of any kind just
formulars
in the cells.
I have also thought about a workaround already which is ok but not ideal,
as
i could simply save the exel file as a text file on the NT machine and
then
work with that textfile in XP, it does not help me getting away from NT
though.

Thanks a million for any suggestions

no you got me wrong, the function will have been executed befor i even get
the file on a server in another country and it will have put data into the
respective fields. The version difference of Exel on my two machines is what
makes the difference now: NT will just keep the values that have been
inserted without applying the formular (which is still put onto that field)
again, whereas the new Exel version will execute the formular again, but that
formular is specific to the server it comes from...

I am opening the same file on a server between the NT and XP machine and
they show different things, as i have explained. But i open the exact same
file! NT will show the value still (althought if i klick in the field it will
update the formular and give the same error) and XP will update at the start
and therefore i dont have the values.

Hope it is more clear now, i am at a point now where i even am pleased with
conversational comments as i have been trying to come up with a reasonable
solution for about a week now...

"Bernard Liengme" wrote:

This has nothing to do with Windows versions but with what Excel files are
stored on the two PCs.
The NAME error indicates a reference to a function that is not present.
What does the formula in that cell read? You need to look for something like
=Personal.xls.SOMEFUNCTION(argument). The you need to copy that file (or the
functions in it) from the NT machine to the second PC
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kataklist" wrote in message
...
Ok here it goes, I am currently working with an Excell sheet that is sent
to
me daily with updated values and I am running a macro over this sheet in
Windows NT! There the macro works fine but when i try to reprogram the
procedure into Windows XP it wont work. I have by now figured out the
reason
for this: The file that is sent to me has several formulars on cells, that
are not defined on my machine therefor if i open the excell sheet in XP it
will enter "#NAME?" into the concerning cells. On NT however it doesnt do
so,
as it does not seem to execute the formulars on load, but simply keeps the
values with which the file was last saved.
Ok, so what i need to know is, can i somehow in VB or in some hidden
properties, tell Exel not to execute the formulars but keep the old values
in
place??
Beware i dont mean links or tables or webquieries of any kind just
formulars
in the cells.
I have also thought about a workaround already which is ok but not ideal,
as
i could simply save the exel file as a text file on the NT machine and
then
work with that textfile in XP, it does not help me getting away from NT
though.

Thanks a million for any suggestions