Microsoft Knowledge Base
Excel Err Msg: Help Reference Is Not Valid
Last reviewed: September 12, 1996
Article ID: Q103096
The information in this article applies to:
- Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
- Microsoft Excel for the Macintosh, version 4.0
SUMMARY
When you attempt to access a custom help topic using the HELP() function, you will receive the following error message if the path specified for the help_ref argument contains 64 or more characters:
Help reference is not valid
The help_ref argument in the HELP() function is a reference to a topic number in a help file, in the form "filename!topic_number". If your custom help file is not located in the current directory, specify the full path along with the name of the file. This 64 character limit pertains only to the path; the filename portion of help_ref is subject to the naming conventions and character limits for your hardware operating system.
MORE INFORMATION
This is a limitation of the MS-DOS operating system. Since you cannot create a subdirectory that would cause the path to be more than 64 characters on a system running MS-DOS, you won't see this particular error in Microsoft Excel for Windows. Although a path in the Apple Macintosh operating system can contain more than 64 characters, Microsoft Excel for the Macintosh also conforms to this limit.
This limitation may also affect other functions that take paths and filenames as arguments. For example, in Microsoft Excel for Windows, the CREATE.DIRECTORY(path_text) function returns FALSE if you try to create a subdirectory that causes the path to exceed 64 characters. This does not occur in Microsoft Excel for the Macintosh.
REFERENCES
"Function Reference," version 4.0, pages 76, 217
KBCategory: kberrmsg Last reviewed: September 12, 1996 |