If you have an excel file that is referenced in several expressions, try creating a string expression with the path to the excel file, then the other expressions reference back to this one. When the excel file path changes, you only need to update one expression in the part file.
myExcelFile = "C:\path\to\excel\file.xslx" exp1 = ug_cell_read(myExcelFile,... exp2 = ug_cell_read(myExcelFile,...
Additionally, there is a journal here that will scan for excel references in your expressions and prompt for a new file or file location.
Has there been any action on the Enhancement Request (ER) 1414636. can I view these requests on this website. if yes, then how?
It's an older ER, reported against NX 3, with no duplicate requests. I'd suggest contacting your local GTAC office and have them add you to the ER. In doing so, the product manager is notified and it brings the ER up to a more current version of NX. BTW, ER's cannot be searched by customers.