Excel 365 Forecast Sheet Missing from the Data Tab: How to Fix
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.

- 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.
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.
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.
Click the cell where you want the first forecast value to appear.
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.
Press Enter, then drag the fill handle across the remaining forecast cells to copy the formula.
Select the historical and forecast data, click Insert, choose a line chart, and format it as needed.

Check Excel 365 version, platform, and ribbon customization
Use this to determine whether the Forecast Sheet button is missing because of a version, licensing, platform, or ribbon configuration issue.
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.

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.




