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

• Microsoft Excel for Windows, versions 5.0, 5.0c

SUMMARY

This article contains the topic numbers and descriptions for the Help topics available in the MAINXL.HLP file. Topic IDs 1-437, listed in the "More Information" section of this article, apply to Microsoft Excel versions 5.0 and 5.0c. For information about topic IDs 438-585, please see the following article(s) in the Microsoft Knowledge Base:

   ARTICLE-ID: Q125231
   TITLE     : "XL5: List of Help Topics in MAINXL.HLP File (Part 2 of 2)"

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; and, 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 topic 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      Description

1          No Help for this Context ID.
2          Locked cells cannot be changed.
3          Microsoft Excel 5.0 menus are required when using Help for Lotus
           1-2-3 Users.
4          Not enough memory to display completely.
5          Database range is not defined.
6          Criteria range is not defined.
7          Extract range is not defined.
8          Database or list range is not valid.
9          Criteria range is not valid.
10         Extract range is not valid.
11         '[Entry]' is not valid.
12         Selection is not valid.
13         Recorder range is not valid.
14         '[Formula or text]' is too long.
15         Formula is too long.
16         Text is too long.
17         Number format is too long.
18         Formula is not valid.
19         Name in formula is unclear.
20         Error in formula.
21         Function is not valid.
22         Parentheses do not match.
23         '[Incorrect number of]' arguments.
24         Error in formula: missing operand.
25         That name is not valid.
26         Cannot enter an external reference to a chart.
27         Cannot enter an external reference to a workbook.
28         Name is not defined.
29         Number format is not valid.
30         Selection is too large.
31         Cannot paste that macro formula onto a worksheet.
32         Cannot resolve circular references.
33         Cannot use workbook reference here.
34         Series order must be an integer between 0 and 255.
35         Series must contain at least one value.
36         Formula must refer to a single cell or result in a text string.
37         External reference is not valid.
38         Reference is not valid. Reference must be to a single cell.
39         Reference is not valid. Reference for categories or values must
           be a single row or column.
40         Reference is not valid.  Reference for error bars must be a row
           or column.
41         Reference is not valid.  Reference must be a simple external
           reference to a worksheet.
42         Reference is not valid.  Reference must be to an open worksheet.
43         Cannot do that command on nonadjacent selections.
44         Cannot use that command on multiple selections.
45         Cannot use a name that refers to nonadjacent cells.
46         Cannot access file '[filename]'.
47         Cannot access directory '[directory name]'.
48         Cannot access '[filename]'.
49         Cannot open or save any more documents.
50         Cannot open files from later versions of Microsoft Excel.
51         Disk is full.
52         Unable to read file.
53         Filename is not valid.
54         Cannot access read-only document '[filename]'.
55         '[External Copy or SYLK]' file format is not valid.
56         Replace existing '[filename]'?
57         Replace existing user-defined format?
58         Cannot save this file with the same name as an open document.
59         '[Filename]' is already open.  Reopening will cause your changes
           to be discarded.  Do you want to reopen?
60         Document is not completely saved.
61         Delete file '[filename]'?
62         Delete this user-defined format?
63         Maximum number of data series per chart is 255.
64         Maximum number of data points in a data series is 4000.
65         Negative or zero values cannot be plotted correctly on log
           charts.
66         No RETURN() or HALT() function found on macro sheet.
67         Reference must be to a macro sheet.
68         Invalid register id, or function not registered yet.
69         Error printing on '[printer]'.
70         No point number is specified.
71         No series number is specified.
72         Tick mark intervals must be greater than 0.
73         That user-defined autoformat option does not exist.
74         No format name specified.
75         Format name must not exceed 31 characters.
76         Format description must not exceed 32 characters.
77         Format name is not valid.
78         Error in deleting format.
79         Error in adding template
80         Error accessing User-defined AutoFormat file
81         Cannot use the autotemplate CHART.XLT. Use the AutoFormat
           Command on the Format menu to create a new custom chart
           autoformat.
82         Format does not exist.
83         You can add the chart template as a user-defined autoformat and
           use it later by choosing AutoFormat from the Format menu. Choose
           Yes to add this template as an autoformat.
84         Cannot print chart in draft quality.
85         Cannot add any more custom formats.
86         '[Filename]' is read-only.
87         '[Filename]' is currently in use. Open as read-only?
88         Sort reference is not valid.
89         This list is outlined. Only the summary data will be sorted.
90         Cannot change part of an array.
91         Cannot change part of a table.
92         Cannot change part of a subscriber.
93         Cannot move or modify part of a pivot table.
94         Pivot table cannot overlap another pivot table.
95         Cannot move part of the filter drop-down row.
96         Cannot delete built-in format.
97         Cannot save to that name.  Another document is linked to a
           document with that name.
98         Value must be a number.
99         Minor unit must be less than major unit.
100        Maximum axis value must be greater than minimum axis value.
101        Unit of log scale must be at least 10.
102       '[Name]' is not a valid name.
103        Replace existing definition of '[name]'?
104        Number is not valid.
105        Integer is not valid.
106        Scroll value must be between 0 and 30000.
107        The scroll value maximum cannot be less than the scroll value
           minimum.
108        That name already exists.
109        No match.
110        No references found.
111        Cannot find matching data.
112        Cannot find matching data to delete.
113        Cannot find matching data to replace.
114        Search string must be specified.
115        Shortcut key must be a letter.
116        Column width must be between 0 and 255 characters.
117        Row height must be between 0 and 409.
118        Recording failed.
119        Recorder range is full.
120        Cannot open the Clipboard.
121        Cannot empty the Clipboard.
122        Too complex to record.
123        Cannot shift nonblank cells off sheet.
124        Cannot shift objects off sheet.
125        Fixed objects will move.
126        Cannot link to a chart.
127        The change to the DDE or OLE link has failed.
128        Number must be greater than or equal to zero.
129        Cannot paste data.
130        Cannot insert object.
131        Cannot open printer driver.
132        File error: data may have been lost.
133        File error. Some number formats may have been lost.
134        File may contain nondisplayable text and formats from the Far
           East.
135        A document with the name '[filename]' is already open.
136        This document contains links. Re-establish links?
137        '[Copy or cut]' and paste areas are different shapes.
138        Cannot paste a table onto a macro sheet.
139        Some custom formats will not fit on the destination sheet.
140        Cannot find '[filename]'.
141        Cannot access '[filename]'.
142        Cannot save '[filename]' because the volume is locked.
143        Matching records will be permanently deleted.
144        Incorrect password.
145        Cannot open a dependent document that contains references to
           different sheets with the same name.
146        Use existing definition of '[name]'?
147        Name cannot resemble a reference.
148        Name cannot be the same as a built-in name.
149        Name already exists on destination sheet.
150        Data on the Clipboard is not the same size and shape as the
           selected area.  Paste anyway?
151        No link to paste.
152        Unable to paste link.
153        No match in active cell.
154        Cell with looping function should not contain anything else.
155        Save changes in '[filename]'?
156        Save changes in '|'? Note: Though you already saved this
           workbook as an Add-In, Add-Ins cannot be viewed or edited.  This
           workbook is the editable version of the Add-In.
157        Save changes in '[filename]'? Note: The current file format is
           not Microsoft Excel Workbook.
158        Reference must be to a single cell.
159        Only macro names are valid.
160        Select cells in one column only.
161        Error in parse line.
162        Cannot find data source.
163        Reference is not valid.
164        Input cell reference is not valid.
165        Destination reference is not valid.
166        Consolidation reference is not valid.
167        Invalid sheet for consolidation.
168        Data will permanently lose accuracy.
169        Sheet is already protected.
170        Custom data_form is not properly defined.
171        Cannot justify cells containing numbers or formulas.
172        Text will extend below selected range.
173        Error in dialog box at '[cell]'.
174        Existing categories will be permanently deleted.
175        There are more new points than series in the chart. Add new
           points to only the existing series?
176        Displayed record will be permanently deleted.
177        Cannot extend list or database.
178        No cells found.
179        Cannot open normal Multiplan document.
180        You must enter a valid reference you want to go to, or type a
           valid name for the selection.
181        Total number of file errors: '[number]'.
182        Cannot read record '[cell or name]'.
183        Cannot write record '[cell or name]'.
184        Cannot convert 3-D reference: '[reference]'.
185        A high-low-close stock chart must contain three series.
186        A volume-high-low-close stock chart must contain four series.
187        An open-high-low-close stock chart must contain four series.
188        A volume-open-high-low-close stock chart must contain five
           series.
189        To use multiple chart types, choose the Chart Type command or
           the chart type group command (for example, Line Group) from the
           Microsoft Excel 5.0 Format menu.
190        Cannot combine 2-D and 3-D types.  Change all series in chart to
           2-D?
191        Cannot combine 2-D and 3-D types.  Change all series in chart to
           3-D?
192        References in series formulas must be external references to
           worksheets.
193        Cannot delete last entry in legend.
194        Redefine '[style]' based on selection?
195        Redefine '[scenario name]' scenario based on current cell
           values?
196        Macro with name '[name]' already exists. Replace existing macro?
197        Cannot create Personal Macro Workbook.
198        Save changes to Personal Macro Workbook?
199        Personal Macro Workbook in the startup directory must stay open
           for recording.
200        You cannot save the Personal Macro Workbook in the startup
           directory. Save it elsewhere now and move it to the startup
           directory later.
201        You cannot save the User-defined AutoFormats Workbook in the
           startup directory. Save it elsewhere now and move it to the
           startup directory later.
202        Cannot save User-defined AutoFormats Workbook.
203        Cannot change this cell while a macro is paused.
204        Too many fields in the data form.
205        Cannot create data form for a database in which all columns are
           hidden.
206        The destination range is not large enough to accommodate all
           copied rows. Data below the destination range will be lost.
           Continue copying anyway?
207        You can only copy filtered data to the active sheet.
208        Microsoft Excel found headers above your list or database.
           Expand selection to include them?
209        This removes the subtotals and sorts again. If you want to sort
           the subtotaled groups, choose the Cancel button; then collapse
           the outline and try again.
210        This subtotals lists in place. To display and remove subtotals
           in a pivot table, use the PivotTable Field command.
211        Too many different cell formats.
212        Note will be permanently deleted.
213        Selected sheets will be permanently deleted. Continue?
214        Sheet name is too long.
215        Only worksheets and charts will be saved.
216        Cannot save as a WK3 file if there are no worksheets in the
           workbook.
217        Save large Clipboard from '[filename]'?
218        Cannot quit Microsoft Excel.
219        Save '[filename]' with references to unsaved documents?
220        Help reference is not valid.
221        Cannot delete '[filename]'.
222        Margins do not fit page size.
223        Number must be between '[number]' and '[number]'.
224        '[Name]' on '[filename]' is not defined or is too complex.
225        Merge styles that have the same names?
226        Database is hidden.
227        Cannot enter a formula in a data form.
228        Cannot save as that name. Document was opened as read-only.
229        Save changes to selected series?
230        Name conflict.  Rename the document you want to open.
231        Dialog box contains too many items.
232        Cannot open protected file.
233        Font name is too long.
234        Text extends beyond worksheet.  Some text will be lost.
235        Command not available at cell:
236        There is nothing to print in the specified pages.
237        Cannot create backup file.  Save '[filename]' without backup?
238        File format is not valid.
239        Cell must contain a value.
240        Reference must be on the active sheet.
241        Cell must contain a formula.
242        Formula in cell must result in a number.
243        Calculation is incomplete. Recalculate before saving?
244        '[Filename or formula]' contains incomplete calculation.
245        '[Filename]' contains incomplete calculation.  Continue
           reporting each error?
246        Operation failed. '[Filename]' is reserved by '[user]'.
247        Operation failed. '[Filename]' is write reserved.
248        Confirmation password is not identical.
249        Password contains accented characters or certain punctuation
           marks which will not transfer correctly to Microsoft Excel for
           Windows or OS/2.
250        Cannot link to Microsoft Excel 1.5 file.
251        '[Document]' is being modified by '[user]'. Open as read-only?
252        '[Document]' should be opened as read-only unless you need to
           save changes to it. Open as read-only?
253        Cell with block IF function should not contain anything else.
254        Reference is too complex.
255        Cannot use that command on a protected sheet.
256        Reference must be to a single cell on the active sheet.
257        Cannot find macro '[name]'.
258        Series definition must include a '[Y or Z]' reference.
259        Saving to an old file format; data may be lost.
260        Cannot find '[macro]', which has been assigned to run each time
           '[document]' is opened. Continuing could cause errors. Cancel
           opening '[document]'?
261        Cannot find '[macro]', which has been assigned to run each time
           '[document]' is closed. Continuing could cause errors. Cancel
           closing '[document]'?
262        Cannot find '[name]'.
263        Cannot start the source application for this object.
264        Cannot find the source application for this embedded object.
265        Sheet is protected with password.  File format cannot be used.
266        Sheet is protected with password and formulas are displayed.
           File format cannot be used.
267        Value is too large.
268        Value is too small.
269        Unable to import file.
270        Unable to combine file.
271        Unable to extract file.
272        Cannot import from an open file.
273        Cannot extract to an open file.
274        Directory does not exist.
275        Matrix must be square.
276        Matrices are incompatible for multiplication.
277        Output range extends beyond edge of worksheet.
278        Cannot split when windows are locked.
279        Reference cannot be to a closed sheet.
280        Lotus 1-2-3 Help demonstrations cannot be recorded.  Stop
           recording and continue?
281        Cannot post instructions because a worksheet is not active.
282        Cannot post instructions because worksheet objects are currently
           hidden or protected.
283        Cannot post instructions because worksheet is protected.
284        Not enough data for Graph demonstration.
285        Cannot demo with custom menus.
286        You cannot use Help for Lotus 1-2-3 Users while in group edit
           mode.
287        Can only paste a subscriber onto a worksheet or macro sheet.
288        Missing NEXT function for loop.
289        Missing loop.
290        Missing IF.
291        Missing an END.IF function.
292        Cannot add another menu bar.
293        Duplicate menu bar name.
294        Command or menu does not exist.
295        Cannot delete built-in or active menu bars.
296        Cannot enable built-in commands.
297        Names cannot look like references.
298        References in object formulas must be external references to
           worksheets.
299        Cannot use name that is a noncontiguous reference.
300        Multiple selection usage is not valid.
301        Cannot change linked data: '[message]'.
302        Source worksheet is closed
303        Data point corresponds to a formula on a macro sheet
304        Cell in source worksheet is locked
305        Cell in source worksheet contains nonnumeric data
306        Category range contains nonnumeric data
307        Stationery document is not saved in Normal format. Opening as a
           nonstationery file.
308        Names are not valid in complex references.
309        Series formula is too long.
310        The list and decimal separators specified by the system are
           identical.  Substituting '[punctuation mark]' for the list
           separator.
311        The date and time separators specified by the system are
           identical.  Substituting ':' for the time separator.
312        Text in your macro may need to be translated manually.
313        Cannot cut part of a publisher.
314        No objects found.
315        Unable to save external link values.
316        Cannot print chart with the current scale and paper size. Select
           a larger scale percentage or a smaller paper size.
317        Update embedded objects?
318        Workbook is protected and cannot be changed.
319        This chart plots data from more than one worksheet.  Double-
           click the series you want to change, and then select the Name
           and Values tab to change the series' plot data.
320        This chart plots constant data.  Double-click the series you
           want to change, and then select the Name And Values tab to
           change the series' plot data.
321        This chart plots data from a closed worksheet. Use the Links
           command on the Edit menu to open the source workbook.
322        Update '[filename]'?
323        Cannot run '[program]'. The program or one of its components is
           damaged or missing.
324        A surface chart must contain at least two series.
325        This button can be used only with Microsoft Windows for Pen
           Computing.
326        Cannot read this binary file. If the file was created in a
           version of Microsoft Excel later than 5.0, use that version to
           save it as a Microsoft Excel 5.0 file. Open file as text?
327        Cannot rename a sheet with the same name as another sheet.
328        Cannot rename a sheet to the same name as another sheet, a
           referenced object library or a workbook referenced by Visual
           Basic.
329        '[Filename]' was created in a previous version of Microsoft
           Excel. Do you want to update it to Microsoft Excel 5.0 format?
330        Sheet name is not valid.
331        Cannot enter an array formula into a range of cells which are
           not all locked or all unlocked.
332        Print titles must be contiguous and complete rows or columns.
333        Macro error at cell: '[reference]'.
334        Macro interrupted at cell: '[reference]'.
335        Illegal reference argument at: '[reference]'
336        Formula is too complex to be assigned to object.
337        Delete the '[name]' toolbar?
338        Cannot revert a file that is currently running a macro.
339        Cannot open a copy while the template '[template]' is open.
340        File not loaded completely.
341        The version of XLINTL.DLL is incorrect. Continuing can cause
           severe errors. Quit Microsoft Excel?
342        Macro name is not valid.
343        This font style name does not exist.
344        Select a font name.
345        No headers detected. Assume top row of selection is header row?
346        Delete entire row?
347        Entire subtotal row will be deleted.
348        Microsoft Excel has detected subtotals in your list.  Aborting
           Pivot....
349        You must quit and then restart Microsoft Excel before your
           changes to the standard font will take effect.
350        This command or function is not available when multiple
           workbooks are selected.
351        Embedded object data will be lost. Continue?
352        Cannot use object linking and embedding.
353        Microsoft Excel is waiting for another application to complete
           an OLE action.
354        The object is not responding.  Continue waiting?
355        Not enough stack space to run macro.
356        Your changes will be lost if you update without saving. Continue
           to update?
357        Workbook must contain at least one visible sheet.
358        Selected file type will save only the active sheet.
359        Do you want to save changes before switching file status?
360        Cannot open Microsoft Excel 5.0 Add-In for editing.  Please edit
           the source document instead.
361        There is already a macro assigned to that key. You can use a
           different keyboard shortcut. Assign to that keyboard shortcut
           anyway?
362        Cannot load an empty Microsoft Excel 4.0 workbook.
363        Microsoft Excel 5.0 workspaces cannot contain Microsoft Excel
           4.0 workbooks.  Use 'Save As' to change the file type.
364        Cannot edit a macro on a hidden workbook. Unhide the workbook
           using the Unhide command.
365        Only Visual Basic macros can be deleted using this dialog.
           Delete Microsoft Excel 4.0 macros by editing the macro sheets.
366        Cannot save to that file format. There are references to other
           sheets in this Workbook. Copy this sheet to a different Workbook
           first, then try again.
367        Document saved successfully. Cannot reopen the saved document
           due to low memory. Please close the document.
368        Cannot print file.
369        Cannot set options for this macro because of an error in the
           macro code.
370        Too many files selected.  Microsoft Excel will open or print as
           many of the files as possible.
371        Cannot open Quattro Pro for Windows file.
372        Cannot open Lotus 123 '[version]' file.
373        Macro cannot be edited in place.
374        Cannot create a reference to unsaved workbooks.
375        Cannot edit macro on protected sheet or book.
376        That name is already assigned to a source sheet. Charts cannot
           be source sheets.
377        Selection too large. Continue without Undo?
378        Document not saved.
379        Document not saved. Any previously saved copy has been deleted.
380        No source references specified for consolidation.
381        Cannot open consolidation source file '[filename]'.
382        No data was consolidated.
383        Cannot add duplicate source reference.
384        Consolidate_Area reference is not valid.
385        Source reference overlaps destination area.
386        Cannot create links to consolidation sheet.
387        Cannot show outline symbols because no outline exists on the
           active worksheet. Create an outline?
388        Cannot ungroup.  To start an outline, select the detail rows or
           columns and group them.
389        Modify existing outline?
390        Cannot create an outline.
391        Style name is not valid.
392        Style '[name]' not found.
393        A group must contain two or more sheets.
394        Input and output ranges overlap.
395        The selection already contains only visible cells..
396        Cannot use that command in data entry mode.
397        Data entry range is too small for this action.
398        Insert new page into printer.
399        Cannot end macro in a menu.
400        Macro error at cell: '[reference]'
401        Macro interrupted at cell: '[reference]'
402        AutoFormat cannot detect a table around the active cell. Select
           the range you want to format and choose the command again.
403        No list found. Select a single cell within your list and
           Microsoft Excel will select the list for you.
404        No list found. Select a single cell within your list and
           Microsoft Excel will select the list for you.
405        Continue checking at beginning of sheet?
406        Finished spell checking '[document]'.
407        Cannot initialize spelling checker.
408        Incompatible version of spelling checker.
409        Custom dictionary '[name]' does not exist. Do you want to create
           it?
410        Invalid '[dictionary name]'.
411        Cannot read '[dictionary name]'.
412        Cannot write '[dictionary name]'.
413        Cannot create '[dictionary name]'.
414        Cannot share '[dictionary name]'.
415        Custom dictionary is full.
416        Cannot open '[dictionary name]'.
417        Dictionary is too large.
418        No spelling errors found in '[selected text]'.
419        The word '[word]' is not in the dictionary.  Change anyway?
420        Specify sheet to copy from workbook.
421        Not a workbook.
422        Cannot find that sheet in workbook.
423        Workbook has no bound sheets.
424        Cannot open files with FM? or ALL format directly. Open the
           corresponding WK? file.
425        Replace contents of destination cells?
426        List will be permanently deleted.
427        Cells without simple text were ignored.
428        Some changing cells are part of an array or table and cannot be
           changed.
429        Too many changing cells.  A scenario can have no more than 32
           changing cells.
430        Too many result cells.  A report can have no more than 32 result
           cells.
431        Scenario names must be unique.
432        Names and results of formulas were converted into values.
433        At least one of the changing cells you specified contains a
           formula.  Formulas in changing cells will be replaced by
           constant values when you show a scenario.
434        Too many scenarios to fit in the report.  Some were left out.
435        Some scenario values were too long and had to be truncated.
436        Changing Cells are required.
437        You must specify result cells when creating a scenario pivot
           table report.