Office Settings & Configuration

Excel 365 Forecast Sheet Missing from the Data Tab: How to Fix

Amos GikundaAmos Gikunda Nov 13, 2026 868 views

Question details

The user needs to locate the Forecast Sheet command in Excel 365 or use an alternative forecasting method when the command is missing from the Data tab.

Excel 365 Forecast Sheet Missing from the Data Tab: How to Fix
Product
Microsoft Excel 365
Device & OS
not provided
Scenario
A user opens Excel 365 to create a forecast chart from time-series worksheet data and expects the Forecast Sheet button on the Data tab.
Observed behavior
The Forecast Sheet command is not visible on the Data tab; only worksheet forecasting functions may be available.
Before you start

Open the workbook that contains your time-series data, verify that the Data tab is displayed, and confirm that the workbook is saved in an Excel-compatible format before troubleshooting.

Solution 1Recommended

Use FORECAST.LINEAR or FORECAST.ETS as a formula-based alternative

Use this when the Forecast Sheet button is unavailable but you still need reliable forecast values from existing time-series data.

The Forecast Sheet command normally creates a chart from forecast functions. If the button is missing, you can still calculate the same predicted values directly with FORECAST.LINEAR for linear trends or FORECAST.ETS for seasonal data.

1
Select the target cell

Click the cell where you want the first forecast value to appear.

2
Enter the forecasting formula

Type =FORECAST.LINEAR(target_date, known_y_values, known_x_values) for a linear trend, or =FORECAST.ETS(target_date, known_y_values, known_x_values) for seasonal data.

3
Confirm and fill the range

Press Enter, then drag the fill handle across the remaining forecast cells to copy the formula.

4
Create a chart

Select the historical and forecast data, click Insert, choose a line chart, and format it as needed.

Use FORECAST.LINEAR or FORECAST.ETS as a formula-based alternative
FORECAST.LINEAR is the modern replacement: FORECAST.LINEAR replaces the older FORECAST function and is available in current Excel versions.
Free Microsoft Office alternative

Use WPS Spreadsheets as a Free Alternative for Excel Forecasting Tasks

If Excel 365 Forecast Sheet is unavailable due to a licensing or platform limitation, WPS Office provides a free, lightweight alternative. WPS Spreadsheets opens and saves Excel .xlsx files, keeps a familiar ribbon interface, and includes forecasting functions and chart tools for daily prediction work without a Microsoft 365 subscription.

Free spreadsheet forecasting functions and chart creation for Excel workbooksOpens, edits, and saves Microsoft Excel .xlsx files without conversionLightweight and familiar ribbon interface similar to Microsoft ExcelCross-platform support for Windows, macOS, Android, and iOS
microsoft office alternative - wps office

Frequently Asked Questions

Why is Forecast Sheet missing from my Excel 365 Data tab?

It can be absent because of an older Excel build, platform, licensing plan, or customized ribbon. Check File > Account, update Excel, and open Customize the Ribbon to see if the command is available.

Can I still create a forecast without the Forecast Sheet button?

Yes. Use =FORECAST.LINEAR(target_date, known_y_values, known_x_values) for linear forecasts or =FORECAST.ETS for seasonal data, then select the data and insert a line chart from the Insert tab.

Does WPS Spreadsheets have forecast sheet functionality?

WPS Spreadsheets includes forecasting functions and chart tools that can open .xlsx workbooks and calculate predictions, making it a practical free alternative when the Excel command is unavailable.

Is FORECAST.LINEAR available in Excel 365?

Yes. FORECAST.LINEAR is available in current Excel 365 versions and is the modern replacement for the older FORECAST function.

How do I add Forecast Sheet to the Data tab ribbon?

Right-click the ribbon, choose Customize the Ribbon, expand Data, and add Forecast Sheet to a visible group if your Excel build supports it. Then click OK to save the ribbon change.