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

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

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