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