197101Too many scenarios to fit in the report. Some were left out.
197102Some scenario values were too long and had to be truncated.
197103Changing Cells are required.
197104You must specify result cells when creating a scenario PivotTable report.
197105Scenario information will be lost.
197106Cannot change a cell containing a string of more than 255 characters.
197107Cannot open PivotTable source file '|'.
197108The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field.
197109"This command requires at least two rows of source data. You cannot use the command on a selection in only one row. Try the following:
• If you're using an advanced filter, select a range of cells that contains at least two rows of data. Then click the Advanced Filter command again.
• If you're creating a PivotTable report or PivotChart report, type a cell reference or select a range that includes at least two rows of data."
197110Not all source records have been copied.
197111No item of this name exists in the PivotTable report. Rename '|1' to '|0'?
197112Cannot move a data field button that does not appear in the PivotTable report.
197113"At least one item must be showing.
If you don't want to show the field at all, cancel the current operation, and then drag the field out of the report.."
197114Too many items are hidden. Unhide some items to continue.
197115A field in your source data has more unique items than can be used in a PivotTable report. Microsoft Excel may not be able to create the report, or may create the report without the data from this field.
197116Cannot create a PivotTable report on a hidden sheet.
197117Because the query for this page field does not return any items, the options for the field cannot be changed. If you expected the field to have items, go back to Microsoft Query and change the query so that the result set includes data for this field (see Help in Microsoft Query).
197118"Microsoft Excel cannot refresh a PivotTable report until refresh of the external data range on which the report is based is complete.
When refresh is finished (the spinning world icon no longer appears in the status bar), click a cell in the report, and then click Refresh Data on the PivotTable toolbar."
197119Cannot show detail data for that selection. If the source database has more detailed data that you want to view, click OK, click an item in a row or column field, and then click Show Detail on the PivotTable toolbar.
197120No data fields are available in the OLAP Cube.
197121"The organization or content of the OLAP cube has been changed and, as a result, no data items are available for display in this PivotTable report.
Consult your database administrator."
197122Cannot show or hide detail for this selection.
197123Cannot change this part of a PivotTable report.
197124Cannot edit a |0 in group edit mode.
197125Cannot edit |0 on protected sheet.
197126Cannot edit |0 in data entry mode.
197127"You cannot create or make changes to PivotTable reports in a shared workbook. If you copy a report and paste it in a shared workbook, only the cell contents are pasted.
To make a copy that you can edit and rearrange, paste the report into a workbook that is not shared."
197128You cannot create or make changes to PivotChart reports in a shared workbook. To make a copy that you can edit and rearrange, paste the PivotTable report that the PivotChart report depends on into a workbook that is not shared, and create a PivotChart report from it.
197129Please wait until Microsoft Excel has finished refreshing the PivotTable report, and then try the command again.
197130Microsoft Excel is placing the PivotTable report on a new sheet, so that it won't overwrite existing data in your workbook. When you run the macro you just recorded, Microsoft Excel won't automatically place the report on a new sheet.
197131"The Top 10 AutoShow options are turned on for this field. To retain this setting, click OK, and then click Cancel in the list of items for the field.
If you click OK and then click OK in the list of items for the field, the Top 10 AutoShow options will be turned off, and the items selected in the list will be displayed instead of the AutoShow items."
197132Cannot paste items into a different field.
197133Cannot paste items into a different group of items.
197134Cannot change that part of a PivotTable report.
197135Cannot enter a formula for an item or field name in a PivotTable report.
197136Cannot enter a null value as an item or field name in a PivotTable report.
197137You cannot hide this selection.
197138Cannot move subtotals or block totals.
197139Cannot edit subtotal, block total, or grand total names.
197140Cannot delete every item of '|' field from the PivotTable report.
197141Cannot hide the (all) item of a page field.
197142Cannot delete the last item in a page field.
197143Cannot move a PivotTable report to a macro sheet.
197144You have not specified any source ranges for your PivotTable report. Type or select at least one range in the Ranges box before choosing Next or Finish.
197145The PivotTable report will not fit on the sheet. Do you want to show as much as possible?
197146Cannot determine which PivotTable field to sort by.
197147Cannot sort items in a page field.
197148Cannot create a PivotTable report on a macro sheet.
197149Cannot move a data field button to a page orientation.
197150Cannot paste a link into a PivotTable report.
197151Cannot make this change. The PivotTable report does not contain this field.
197152'|' is not an item of this field.
197153"There is not enough memory available to create the PivotTable report. To make more memory available, try the following:
• Reduce the number of column or row fields you include in the PivotTable report.
• Close files or programs you aren't using."
197154Number must be greater than zero.
197155Cannot group that selection.
197156Cannot ungroup that selection.
197157"You cannot group items in this field because it's set to query for each item separately when it's in the page position.
Drag the field to the page position, double-click the field button, click Advanced, and click the Retrieve External Data For All Page Field Items option. Then try grouping the items again."
197158Ending value must be greater than starting value.
197159This PivotTable report is not valid.
197160"You must specify a data field. The available fields appear on the right side of the Layout dialog box. Drag a field and drop it in the area labeled DATA.
For more information about dragging fields to summarize data, click OK, and then click the Help button in the dialog box."
197161You have entered an invalid source range for your PivotTable report. Enter a valid range in the Ranges box and then choose Add.
197162A PivotTable report with that name already exists on the destination sheet.
197163PivotTable name is not valid.
197164PivotTable field name already exists.
197165Replace crosstab table with PivotTable report?
197166Replace crosstab table with PivotTable report, ignoring criteria range?
197167Excel could not get the source data for the PivotTable report from the disk.
197168The Refresh Data operation changed the PivotTable report.
197169Microsoft Excel did not receive any information from Microsoft Query.
197170To use this feature, you must have a World Wide Web browser, such as Microsoft Internet Explorer.
197171This Web query returned no data. To modify the query, click OK, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar.
197172Microsoft Query could not be started because it isn't installed. You can install Query by running the installation program you used to install Office or Excel. The Query option is in the Office Tools category.
197173Microsoft Query is already running, but is not responding to Microsoft Excel. Switch to Microsoft Query and make sure that there are no dialog boxes open or that Microsoft Query is not busy retrieving data.
197174Microsoft Query is busy editing another query for Microsoft Excel. You can not edit more than one query at a time from within Microsoft Excel. Switch back to Microsoft Query to complete (or cancel) the editing operation currently in progress.
197175No data source specified.
197176Problems obtaining data.
197177The PivotTable report was saved without the underlying data. Use the Refresh Data command to update the report.
197178Data will be saved with other PivotTable reports using the same source data as this report.
197179Data will not be saved with other PivotTable reports using the same source data as this report.
197180Changes to the Background Query option also change the option for other PivotTable reports based on the same source data. From now on, when you refresh the other reports, the query for external data will also be run in the background.
197181Changes to the Background Query option also change the option for other PivotTable reports based on the same source data. From now on, when you refresh the other reports, the query for external data will also be run while you wait.
197182To save this web page to the current
location, it needs to be saved using short file names, which requires organizing supporting files in a folder. However, you don't have privileges to create a folder in the current
location.197183The folder that this Web page would use to organize supporting files is already reserved for use in the current
location. Please choose a different name or
location for this Web page.
197184Changes to the Optimize Memory option also change the option for other PivotTable reports based on the same source data. From now on, memory will also be optimized for the other reports.
197185Changes to the Optimize Memory option also change the option for other PivotTable reports based on the same source data. From now on, memory optimization will also be turned off for the other reports.
197186Changes to the Refresh On Open option also change the option for other PivotTable reports based on the same source data. From now on, whenever you open this workbook, data will also be refreshed in the other reports.
197187Changes to the Refresh On Open option also change the option for other PivotTable reports based on the same source data. From now on, whenever you open this workbook, data also will not be refreshed in the other reports.
197188Changes to the Save Password option also change the option for other PivotTable reports based on the same source data. From now on, the database password will also be saved for the other reports.
197189Changes to the Save Password option also change the option for other PivotTable reports based on the same source data. From now on, the database password also will not be saved for the other reports.
197190References, names, and arrays are not supported in PivotTable formulas.