XL5: List of Help Topics in MAINXL.HLP File (Part 2 of 2)

ID: Q125231


The information in this article applies to:


SUMMARY

This article contains the topic numbers and descriptions for the topics available in the MAINXL.HLP file. Topics 438-585 for Microsoft Excel 5.0 are different from those for 5.0c; therefore, these topics are listed under separate headings. For information about topic IDs 1-437, please see the following article(s) in the Microsoft Knowledge Base:

Q125230 : "XL5: List of Help Topics in MAINXL.HLP File (Part 1 of 2)"

Note that topics 1-437 apply to Microsoft Excel version 5.0 AND Microsoft Excel version 5.0c.

Using a Help Topic

You can use these topics in conjunction with dialog boxes that are equipped with Help buttons; you can call them with the HELP() function in Microsoft Excel 4.0; or, you can call them with the Application.Help line in a Visual Basic, Applications Edition, macro. The following are examples of both types of macros.


   Visual Basic code:

      Application.Help "MAINXL.HLP", 3

   Microsoft Excel 4.0 macro:

      =HELP("MAINXL.HLP!3") 


Finding a Help Topic ID

To find the help topic ID numbers for a help file in Microsoft Excel, use the following macro:

HELP_TOPICS
=FOR("Message",1,395)
=HELP("Mainxl.hlp!"&Message)
=SEND.KEYS("%EC+{END}+{DOWN}%C")
=FORMULA(Message,OFFSET(!A1,Message,0))
=PASTE(OFFSET(B1,Message,0))
=NEXT()
=RETURN()


MORE INFORMATION

Topic IDs 438-585 for Microsoft Excel version 5.0 only

Topic      Description 

Note: The topic numbers in this section may be off by one row. Please bear this fact in mind when using these topic numbers to display specific help topics.


438        Cannot open pivot table source file '[filename]'.
439        Pivot table field name is not valid.
440        The source database must have at least one record.
441        Not all source records have been copied.
442        No item of this name exists in the pivot table. Rename '[current
           item name]' to '[proposed item name]'?
443        Cannot pivot a data field button that does not appear in the
           pivot table.
444        At least one item must be showing. Choose the Delete button to
           hide the field.
445        Too many items are hidden. Unhide some items to continue.
446        Too many items to create pivot table.
447        Cannot create a pivot table on a hidden sheet.
448        Cannot show or hide detail for this selection.
449        Cannot change this part of a pivot table.
450        Cannot edit a pivot table in group edit mode.
451        Cannot edit pivot table on protected sheet.
452        Cannot edit pivot table in data entry mode.
453        Cannot paste items into a different field.
454        Cannot paste items into a different group of items.
455        Replacement creating duplicate item or field name ignored.
456        Cannot enter a formula into a pivot table.
457        Cannot enter a null value as an item or field name in a pivot
           table.
458        Cannot delete this selection from the pivot table.
459        Cannot move subtotals or block totals.
460        Cannot edit subtotal, block total, or grand total names.
461        Cannot delete every item of '[field name]' field from the pivot
           table.
462        Cannot hide the (all) item of a page field.
463        Cannot delete the last item in a page field.
464        Cannot move a pivot table to a macro sheet.
465        You have not specified any source ranges for your pivot table.
           Type or select at least one range in the Ranges box before
           choosing Next or Finish.
466        Cannot show or hide detail for the data area.
467        Pivot table will not fit on sheet. Show as much as possible?
468        Cannot determine which pivot table field to sort by.
469        Cannot sort items in a page field.
470        Cannot create a pivot table on a macro sheet.
471        Cannot pivot data field button to a page orientation.
472        Cannot paste a link into a pivot table.
473        Cannot pivot. Pivot table does not contain this field.
474        '[Text]' is not an item of this field.
475        Not enough memory to completely display pivot table.
476        Number must be greater than zero.
477        Cannot group that selection.
478        Cannot ungroup that selection.
479        Ending value must be greater than starting value.
480        Pivot table is not valid.
481        Specify a data field.
482        You have entered an invalid source range for your pivot table.
           Enter a valid range in the Ranges box and then choose Add.
483        A pivot table with that name already exists on the destination
           sheet.
484        Pivot table name is not valid.
485        Pivot table field name already exists.
486        Replace crosstab table with PivotTable?
487        Replace crosstab table with PivotTable, ignoring criteria
           range?
488        Unable to obtain PivotTable data from disk.
489        Pivot table was changed during Refresh Data operation.
490        Problems obtaining Microsoft Query data.
491        No data source specified.
492        Problems obtaining data.
493        Pivot table saved without underlying data. Use the Refresh Data
           command to update the pivot table.
494        Data will be saved with other pivot tables using the same source
           data as this pivot table.
495        Data will not be saved with other pivot tables using the same
           source data as this pivot table.
496        Copy '[add-in]' to Microsoft Excel Add-in library?
497        Unable to copy add-in to library.
498        '[Add-in name]' is not a valid add-in.
499        Cannot find add-in '[add-in]'. Delete from list?
500        Value must be greater than zero..
501        Value must be greater than or equal to zero.
502        Value must be between zero and 0.5.
503        Polynomial order must be an integer from 2 through 6.
504        Moving Average must have a period that is greater than one and
           less than the number of points in the source data series.
505        Some trendlines cannot be calculated from data containing
           negative or zero values.
506        The name '[name]' is unknown. Specify a valid name.
507        '[Document]' has a routing slip.  Route now to '[name]'?
508        General mail failure. Quit Microsoft Excel, restart the mail
           system, and try again.
509        Your mail system does not support certain services needed for
           document routing.
510        Too many mail sessions. Quit other mail sessions and try again.
511        Too many recipients specified.  Route the document several times
           to smaller groups of recipients.
512        Message too long for your mail system. Shorten the message and
           try again.
513        Cannot send status tracking message.
514        Too many recipients specified. Send the document several times
           to smaller groups of recipients.
515        Unknown recipient name found in the recipient list.  Use a valid
           name and try again.
516        Ambiguous recipient name found in the recipient list.  Use a
           valid name and try again.
517        You must exit Windows and load SHARE.EXE in order to run
           Microsoft Excel.
518        Microsoft Excel cannot display the Network dialog box.
519        An error occurred while Microsoft Excel was attempting to use
           the system Network dialog box.
520        The graphics filter cannot convert the picture file
           '[filename]'.
521        Microsoft Excel cannot find the necessary graphics filter.
522        The name '[filename]' is a reserved device name.  Use a
           different filename.
523        Number is not valid.
524        Text is not valid.
525        Logical value is not valid.
526        Reference is not valid.
527        Error value is not valid.
528        Type is not valid.
529        Array value is not valid.
530        An error occurred initializing the VBA libraries
531        One of your object libraries (|) is missing or damaged.
532        '[Object]' does not have '[property name]' property
533        '[Object]' does not have '[method name]' method
534        Missing required argument '[argument]'
535        '[Method name]' method of '[object]' class failed
536        Unable to set the '[property name]' property of the '[object]'
           class
537        Unable to get the '[property name]' property of the '[object]'
           class
538        Cannot run Visual Basic macro because of a syntax error.
539        Workbook is already protected.
540        Invalid number of arguments.
541        An Excel lexicon '[filename]' is missing or damaged.
542        VBA Lexicon is wrong version.
543        VBA Lexicon is wrong type (ship vs debug)
544        You cannot edit when calculating a user defined function.
545        Not enough stack space to perform command.
546        '[Object]' does not have writeable '[property name]' property.
547        '[Object]' does not have readable '[property name]' property
548        No timer driver installed
549        No data was selected to parse.
550        The Trace Precedents command requires that the active cell
           contain a formula.
551        The Trace Dependents command found no formulas that refer to the
           active cell.
552        The Trace Error command requires that the active cell contain an
           error value.
553        The Remove All Arrows command found no tracer arrows to remove.
554        The Error Tracer has encountered a branch point. Double-click
           the branch you want to follow and choose Trace Error again.
555        The Error Tracer encountered existing arrows or a circular
           reference. Delete all tracer arrows or resolve the circular
           reference, and then choose Trace Error again.
556        OLE Objects cannot be active while debugging.  Your code may
           execute differently in the debug window because the currently
           active OLE Object will be automatically deactivated.
557        Cannot edit chart objects while Microsoft Excel 5.0 is in place
           editing.
558        Document saved as '[filename]'. Cannot rename to '[filename]'.
           You must close this document.
559        Font size must be between 1 and 409.
560        Cannot find '[linked document]'.
561        Cannot open chart created in Microsoft Excel for the Macintosh
           version 1.X.
562        Cannot open normal document created in Microsoft Excel for the
           Macintosh.
563        No Help Topic for this ID
564        Remote data not accessible. Start application '[application]'?
565        Existing remote links will be terminated.
566        Current printer is unavailable. Select another printer.
567        There are no printers installed. Use the Printers option in
           Control Panel to install a printer.
568        Cannot run tutorial with Microsoft Windows for Pen Computing.
569        The header or footer cannot be longer than 255 characters.
           Delete some text, or make the  formatting less complex.
570        CBTLIB4.DLL not found. Cannot run tutorial.
571        EXCELCBT.CBT not found. Cannot run tutorial.
572        Lesson file(s) not found. Cannot run tutorial.
573        EXCELCBT directory not found.
574        Cannot run tutorial. There may be another instance of tutorial
           active.
575        No Help Topic for this ID
576        Too many files to mail.
577        Cannot load the mail service. Check your mail installation.
578        Mail system failure. Check your mail installation.
579        The picture is too large and will be truncated.
580        File is not a valid wave file.
581        Recording buffer is full.
582        Cannot load wave file.
583        Cannot open waveform output device.
584        Cannot open waveform input device.
585        Cannot play Macintosh sounds with Windows. 


Topic IDs for Microsoft Excel version 5.0c only




Topic      Description
-----      ----------------------------------------------------------------

438        Scenario information will be lost.
439        Cannot open pivot table source file '[filename]'.
440        Pivot table field name is not valid.
441        The source database must have at least one record.
442        Not all source records have been copied.
443        No item of this name exists in the pivot table. Rename '[current
           item name]' to '[proposed item name]'?
444        Cannot pivot a data field button that does not appear in the
           pivot table.
445        At least one item must be showing. Choose the Delete button to
           hide the field.
446        Too many items are hidden. Unhide some items to continue.
447        Too many items to create pivot table.
448        Cannot create a pivot table on a hidden sheet.
449        Cannot show or hide detail for this selection.
450        Cannot change this part of a pivot table.
451        Cannot edit a pivot table in group edit mode.
452        Cannot edit pivot table on protected sheet.
453        Cannot edit pivot table in data entry mode.
454        Cannot paste items into a different field.
455        Cannot paste items into a different group of items.
456        Replacement creating duplicate item or field name ignored.
457        Cannot enter a formula into a pivot table.
458        Cannot enter a null value as an item or field name in a pivot
           table.
459        Cannot delete this selection from the pivot table.
460        Cannot move subtotals or block totals.
461        Cannot edit subtotal, block total, or grand total names.
462        Cannot delete every item of '[field name]' field from the pivot
           table.
463        Cannot hide the (all) item of a page field.
464        Cannot delete the last item in a page field.
465        Cannot move a pivot table to a macro sheet.
466        You have not specified any source ranges for your pivot table.
           Type or select at least one range in the Ranges box before
           choosing Next or Finish.
467        Cannot show or hide detail for the data area.
468        Pivot table will not fit on sheet. Show as much as possible?
469        Cannot determine which pivot table field to sort by.
470        Cannot sort items in a page field.
471        Cannot create a pivot table on a macro sheet.
472        Cannot pivot data field button to a page orientation.
473        Cannot paste a link into a pivot table.
474        Cannot pivot. Pivot table does not contain this field.
475        '[Text]' is not an item of this field.
476        Not enough memory to completely display pivot table.
477        Number must be greater than zero.
478        Cannot group that selection.
479        Cannot ungroup that selection.
480        Ending value must be greater than starting value.
481        Pivot table is not valid.
482        Specify a data field.
483        You have entered an invalid source range for your pivot table.
           Enter a valid range in the Ranges box and then choose Add.
484        A pivot table with that name already exists on the destination
           sheet.
485        Pivot table name is not valid.
486        Pivot table field name already exists.
487        Replace crosstab table with pivot table?
488        Replace crosstab table with pivot table, ignoring criteria
           range?
489        Unable to obtain PivotTable data from disk.
490        Pivot table was changed during Refresh Data operation.
491        Problems obtaining Microsoft Query data.
492        No data source specified.
493        Problems obtaining data.
494        Pivot table saved without underlying data. Use the Refresh Data
           command to update the pivot table.
495        Data will be saved with other pivot tables using the same source
           data as this pivot table.
496        Data will not be saved with other pivot tables using the same
           source data as this pivot table.
497        Copy '[add-in]' to Microsoft Excel Add-in library?
498        Unable to copy add-in to library.
499        '[Add-in name]' is not a valid add-in.
500        Cannot find add-in '[add-in]'. Delete from list?
501        Value must be greater than zero..
502        Value must be greater than or equal to zero.
503        Value must be between zero and 0.5.
504        Polynomial order must be an integer from 2 through 6.
505        Moving Average must have a period that is greater than one and
           less than the number of points in the source data series.
506        Some trendlines cannot be calculated from data containing
           negative or zero values.
507        The name '[name]' is unknown. Specify a valid name.
508        '[Document]' has a routing slip.  Route now to '[name]'?
509        General mail failure. Quit Microsoft Excel, restart the mail
           system, and try again.
510        Your mail system does not support certain services needed for
           document routing.
511        Too many mail sessions. Quit other mail sessions and try again.
512        Too many recipients specified.  Route the document several times
           to smaller groups of recipients.
513        Message too long for your mail system. Shorten the message and
           try again.
514        Cannot send status tracking message.
515        Too many recipients specified. Send the document several times
           to smaller groups of recipients.
516        Unknown recipient name found in the recipient list.  Use a valid
           name and try again.
517        Ambiguous recipient name found in the recipient list.  Use a
           valid name and try again.
518        You must exit Windows and load SHARE.EXE in order to run
           Microsoft Excel.
519        Microsoft Excel cannot display the Network dialog box.
520        An error occurred while Microsoft Excel was attempting to use
           the system Network dialog box.
521        The graphics filter cannot convert the picture file
           '[filename]'.
522        Microsoft Excel cannot find the necessary graphics filter.
523        The name '[filename]' is a reserved device name.  Use a
           different filename.
524        Number is not valid.
525        Text is not valid.
526        Logical value is not valid.
527        Reference is not valid.
528        Error value is not valid.
529        Type is not valid.
530        Array value is not valid.
531        An error occurred initializing the VBA libraries [filename]
532        One of your object libraries (|) is missing or damaged.
533        '[Object]' does not have '[property name]' property
534        '[Object]' does not have '[method name]' method
535        Missing required argument '[argument]'
536        '[Method name]' method of '[object]' class failed
537        Unable to set the '[property name]' property of the '[object]'
           class
538        Unable to get the '[property name]' property of the '[object]'
           class
539        Cannot run Visual Basic macro because of a syntax error.
540        Workbook is already protected.
541        Invalid number of arguments.
542        An Excel lexicon '[filename]' is missing or damaged.
543        VBA Lexicon is wrong version.
544        VBA Lexicon is wrong type (ship vs debug)
545        You cannot edit when calculating a user defined function.
546        Not enough stack space to perform command.
547        '[Object]' does not have writeable '[property name]' property.
548        '[Object]' does not have readable '[property name]' property
549        The Timer driver is not installed on this system. Microsoft
           Excel cannot run without the Timer driver. Choose the help
           button for more information.
550        No data was selected to parse.
551        The Trace Precedents command requires that the active cell
           contain a formula.
552        The Trace Dependents command found no formulas that refer to the
           active cell.
553        The Trace Error command requires that the active cell contain an
           error value.
554        The Remove All Arrows command found no tracer arrows to remove.
555        The Error Tracer has encountered a branch point. Double-click
           the branch you want to follow and choose Trace Error again.
556        The Error Tracer encountered existing arrows or a circular
           reference. Delete all tracer arrows or resolve the circular
           reference, and then choose Trace Error again.
557        OLE Objects cannot be active while debugging.  Your code may
           execute differently in the debug window because the currently
           active OLE Object will be automatically deactivated.
558        Cannot edit chart objects while Microsoft Excel 5.0 is inplace
           editing.
559        Document saved as '[filename]'. Cannot rename to '[filename]'.
           You must close this document.
560        Font size must be between 1 and 409.
561        Cannot find '[linked document]'. Copy from:
562        Cannot open chart created in Microsoft Excel for the Macintosh
           version 1.X.
563        Cannot open normal document created in Microsoft Excel for the
           Macintosh version 1.X.
564        No Help Topic for this ID
565        Cannot open normal document created in Microsoft Excel for the
           Macintosh version 1.X.
566        Existing remote links will be terminated.
567        Current printer is unavailable. Select another printer.
568        There are no printers installed. Use the Printers option in
           Control Panel to install a printer.
569        Cannot run tutorial with Microsoft Windows for Pen Computing.
570        The header or footer cannot be longer than 255 characters.
           Delete some text, or make the formatting less complex.
571        CBTLIB4.DLL not found. Cannot run tutorial.
572        EXCELCBT.CBT not found. Cannot run tutorial.
573        Lesson file(s) not found. Cannot run tutorial.
574        EXCELCBT directory not found.
575        Cannot run tutorial. There may be another instance of tutorial
           active.
576        No Help Topic for this ID
577        Cannot run tutorial. There may be another instance of tutorial
           active.
578        Cannot load the mail service. Check your mail installation.
579        Mail system failure. Check your mail installation.
580        The picture is too large and will be truncated.
581        File is not a valid wave file.
582        Recording buffer is full.
583        Cannot load wave file.
584        Cannot open waveform output device.
585        Cannot open waveform input device. 

Additional query words: 5.0 5.00c HelpContextId


Keywords          : 
Version           : 5.00 5.00c
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: April 13, 1999