Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is ext .xlnm inserted in formula every time I close a doc
I have Excel 2007. I have a formula that works until I close and re-open.
_xlnm. is then inserted in all formulas and makes everything fail. When I manually remove the _xlnm. everything works OK again. The file is saved in the .xlsm format. Turn off the computer and come back the next day, _xlnm. is again in all the formulas what is _xlnm. anyway, what does it stand for? Msg before Fail =VLOOKUP(H3,'J:\external hard drive data\CCCBC\Database and Reader\Learning\2009 CCCBC DataBase.xls'!Database,4) Msg After fail =VLOOKUP(H3,'J:\external hard drive data\CCCBC\Database and Reader\Learning\2009 CCCBC DataBase.xls'!_xlnm.Database,4) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is ext .xlnm inserted in formula every time I close a doc
"JD in Riverbank" wrote: I have Excel 2007. I have a formula that works until I close and re-open. _xlnm. is then inserted in all formulas and makes everything fail. When I manually remove the _xlnm. everything works OK again. The file is saved in the .xlsm format. Turn off the computer and come back the next day, _xlnm. is again in all the formulas what is _xlnm. anyway, what does it stand for? Msg before Fail =VLOOKUP(H3,'J:\external hard drive data\CCCBC\Database and Reader\Learning\2009 CCCBC DataBase.xls'!Database,4) Msg After fail =VLOOKUP(H3,'J:\external hard drive data\CCCBC\Database and Reader\Learning\2009 CCCBC DataBase.xls'!_xlnm.Database,4) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is ext .xlnm inserted in formula every time I close a doc
Hi,
I've seen this once before on this forum and at the time I assumed the VLOOKUP was actually pointing at a different file, but twice, highly unlikely. Here is something you might try, change the file type of the external file to a 2007 file - XLSX or XLSM extension and see if it works. If it doesn't post back. Cheers, Shane Devenshire "JD in Riverbank" wrote: I have Excel 2007. I have a formula that works until I close and re-open. _xlnm. is then inserted in all formulas and makes everything fail. When I manually remove the _xlnm. everything works OK again. The file is saved in the .xlsm format. Turn off the computer and come back the next day, _xlnm. is again in all the formulas what is _xlnm. anyway, what does it stand for? Msg before Fail =VLOOKUP(H3,'J:\external hard drive data\CCCBC\Database and Reader\Learning\2009 CCCBC DataBase.xls'!Database,4) Msg After fail =VLOOKUP(H3,'J:\external hard drive data\CCCBC\Database and Reader\Learning\2009 CCCBC DataBase.xls'!_xlnm.Database,4) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why does xlnm get superimposed in my formulas upon exit | Excel Worksheet Functions | |||
long time to close spreadsheet | Excel Discussion (Misc queries) | |||
How can I close all excel spreadsheets at one time? | Excel Discussion (Misc queries) | |||
Automatically have the date or time inserted into a cell | Excel Discussion (Misc queries) | |||
I only want to save and close one window at a time (like Word) | Setting up and Configuration of Excel |