Normally, MS Excel’s names refer to a worksheet range and have a value. Users can access the names from the worksheet’s ‘NameBox’.
I have downloaded an Excel file from the Enron collection, which does not appear to have names associated with the workbook. The ‘NameBox’ list is empty. However, on opening the Name Manager, several names are listed at both Workbook and Worksheet level.
One name, SAPFuncF4Help, is repeated several times at worksheet level for different worksheets and also once at workbook level. There is no value associated with any of the iterations of this repeated name and the ‘Refers To’ column lists ‘=main.SAP4Help()’.
Can anyone explain the role of this name within the Name Manager?
Bookmarks