Forum Discussion

Sandro de Souza Caieron's avatar
Sandro de Souza Caieron
Copper Contributor
Sep 11, 2017

Excel 2010 - Forecast worksheet button

I am an IT technician and I have been tracking your work for some time, I have a client that is trying to use an Excel 2010 feature but I can not help because this button is not active, how could I activate it?

 

Or is this feature EXCLUSIVE from Excel 2016?

answered in the email scaieron@hotmail.com
Thank you
Sandro Caieron

 

excel
  • Smitty Smith's avatar
    Smitty Smith
    Icon for Microsoft rankMicrosoft
    Sep 15, 2017

    The Forecast feature was introduced in Excel 2016, so it's not available in Excel 2010. See: Create a forecast in Excel 2016.

     

    If you do have it, but it's not enabled, that would be becase you don't have an appropriate data set. It requires two corresponding data series:

     

    • A series with date or time entries for the timeline
    • A series with corresponding values
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Sep 11, 2017

    Hi Sandro,

     

    I'm almost sure that's for 2016, as well as FORECAST.ETS it uses. You may check support pages for them to check to which versions they apply to.

Resources