why does xlnm get superimposed in my formulas upon exit
 

Hi:
I need to know exactly what xlnm is, because it's messing me up.

I have two excel files, one used as a database [which is on a drive through
my home network] and the other as a reader, {Showing the Database on a more
readable form display},using the VLOOKUP function. This method has worked
properly until i added photos to the reader file. When the file was first up
and the photos inserted, it works perfectly. Click on a file reference and
the data comes up as well as the persons photo. I saved the reader file as a
xlsm extension to save the VB program. Everything works OK. I close the
files and re open them later and the Links to the database are all messed up,
Somehow a _xlnm. is being automatically inserted in front of the VLOOKUP
cell range, which I Named Database

The Link Formula:
=VLOOKUP(H3,'\\Your-4dacd0ea75\wdc usb2 (j)\CCCBC\Database and Reader\2008
CCCBC DataBase.xlsm'!_xlnm.Database,30)

Note the _xlnm. in front of database when the file is reopened. When I
remove the _xlnm. from all formulas everything works OK again. What is xlnm
and why does Excel insert it in the formula. I have VB6 Office 2007,
Vista.

Jimmy D. Carter

why does xlnm get superimposed in my formulas upon exit
 

Hi,

I don't think this is an XML issue, probably your VLOOKUP function is
looking at a different file.
--
Thanks,
Shane Devenshire


"JD in Riverbank" wrote:

Hi:
I need to know exactly what xlnm is, because it's messing me up.

I have two excel files, one used as a database [which is on a drive through
my home network] and the other as a reader, {Showing the Database on a more
readable form display},using the VLOOKUP function. This method has worked
properly until i added photos to the reader file. When the file was first up
and the photos inserted, it works perfectly. Click on a file reference and
the data comes up as well as the persons photo. I saved the reader file as a
xlsm extension to save the VB program. Everything works OK. I close the
files and re open them later and the Links to the database are all messed up,
Somehow a _xlnm. is being automatically inserted in front of the VLOOKUP
cell range, which I Named Database

The Link Formula:
=VLOOKUP(H3,'\\Your-4dacd0ea75\wdc usb2 (j)\CCCBC\Database and Reader\2008
CCCBC DataBase.xlsm'!_xlnm.Database,30)

Note the _xlnm. in front of database when the file is reopened. When I
remove the _xlnm. from all formulas everything works OK again. What is xlnm
and why does Excel insert it in the formula. I have VB6 Office 2007,
Vista.

Jimmy D. Carter

why does xlnm get superimposed in my formulas upon exit
 

Thank You Shane for the Input. It made me take another look at the whole
formula and I kept the reader as an .xlsm file and changed the database back
to a .xls file upon deleting (again) all of the _xlnm. entries from each
vLOOKUP, I toggled every Locked cell check box for the VLOOKUP formula. I
saved the Database Reader file as .xlsm I closed the file and re-opened it
and this time it came back perfectly and all photo entries worked as
expected. Good by...... _xlnm.

"JD in Riverbank" wrote:

Hi:
I need to know exactly what xlnm is, because it's messing me up.

I have two excel files, one used as a database [which is on a drive through
my home network] and the other as a reader, {Showing the Database on a more
readable form display},using the VLOOKUP function. This method has worked
properly until i added photos to the reader file. When the file was first up
and the photos inserted, it works perfectly. Click on a file reference and
the data comes up as well as the persons photo. I saved the reader file as a
xlsm extension to save the VB program. Everything works OK. I close the
files and re open them later and the Links to the database are all messed up,
Somehow a _xlnm. is being automatically inserted in front of the VLOOKUP
cell range, which I Named Database

The Link Formula:
=VLOOKUP(H3,'\\Your-4dacd0ea75\wdc usb2 (j)\CCCBC\Database and Reader\2008
CCCBC DataBase.xlsm'!_xlnm.Database,30)

Note the _xlnm. in front of database when the file is reopened. When I
remove the _xlnm. from all formulas everything works OK again. What is xlnm
and why does Excel insert it in the formula. I have VB6 Office 2007,
Vista.

Jimmy D. Carter