В excel 2013 нет power pivot

runeft, нельзя на 2013 и младше ставить эту надстройку, т.к. она встроена в приложение. Только на 2010.
Проверьте диалоговое окно при создании сводной таблицы, активна ли у вас галочка Добавить данные в модель данных?

Если да, то это и есть обрезанный вариант Power Pivot для

«бедных»

тех у кого не PRO + версия.
В таком случае вы сможете через вот это окошко добавлять таблички в модель данных, через диалоговые окна связей настраивать связи между таблицами, а через настройки сводной таблицы создавать меры. При этом вам будут недоступны возможности по созданию вычисляемых столбцов в таблицах, создание автокалендаря и не сможете использовать коннекторы к данным от PowerPivot. Тем не менее эти вопросы с легкостью решаются при помощи Power Query.

Источник

Важно: В Excel для Microsoft 365 Excel 2021 Power View удаляется 12 октября 2021 г. В качестве альтернативы вы можете использовать интерактивный визуальный эффект, предоставляемый Power BI Desktop,который можно скачать бесплатно. Вы также можете легко импортировать книги Excel в Power BI Desktop. 

Проблемы

После установки Microsoft Excel 2013 розничной торговли надстройки Power Pivot и Power View будут недоступны.

Решение

Чтобы устранить эту проблему, применим оба следующих обновления:

2825684 Описание пакета Excel 2013 (Excel-x-none.msp; Excelintl-en-us.msp): 17 октября 2013 г.

2825654 Описание пакета Office 2013 (Excelpp-x-none.msp): 17 октября 2013 г.

Статус

Корпорация Майкрософт подтверждает наличие этой проблемы в своих продуктах, которые перечислены в разделе «Применяется к».

Нужна дополнительная помощь?

Источник
  • Remove From My Forums

  • Question

  • hi

    I recently change excel 2013 preview to excel profesional 2013 but PowerPivot is missing, what do I have to do, It`s not in the COM add-ins list, I tried too many ways, somebody can help me.

Answers

  • Hi mlvmx,

    PowerPivot in Excel 2013 is an add-in you can use to perform powerful data analysis in Excel 2013. The add-in is available in Microsoft Office Professional Plus. It’s built-into Excel 2013 but is not enabled. Here’s how you enable PowerPivot before you
    use it for the first time.

    1. Go to File > Options >
      Add-Ins.
    2. In the Manage box, click COM Add-ins>
      Go.
    3. Check the Microsoft Office PowerPivot for Excel 2013 box, and then click
      OK. If you have other versions of the PowerPivot add-in installed, those versions are also listed in the COM Add-ins list. Be sure to select the PowerPivot add-in for Excel 2013.

    For more information, please see:
    http://office.microsoft.com/en-001/excel-help/start-powerpivot-in-excel-2013-add-in-HA102837097.aspx

    Regards,

    Elvis Long
    TechNet Community Support

    • Marked as answer by

      Monday, March 4, 2013 2:27 AM

  • Check this out — :(

    http://www.powerpivotpro.com/2013/02/hey-who-moved-my-powerpivot-2013-cheese/

    Update

    Find below the excerpt from MSFT employee

    «Hi all,

    We understand that this puts those of you who have less than ProPlus in a bad position where your previous Excel 2010 workbooks are concerned. You can’t use them in Excel 2013 without updating the data model, and you can’t update the data model without the
    add-in. If you know someone with ProPlus or an Enterprise SKU, you can always ask them to update the workbook and save it in 2013. From there, you should be able to use it.

    For basic PowerPivot functionality, you don’t need the add-in. So you can also recreate your PivotTables in Excel 2013 using the new data model. The key is to select «Add this data to the data model» when you create the pivottable from one of your
    data sources. Then you can import other tables, and use the «All» tab on the field list to add the other information. On either the Data tab or the PivotTable tools Analyze tab, you can create the relationships you need.

    Hope this helps!
    Anita»

    Cheers,
    Jason | www.SqlJason.com
    P.S. : Please click the ‘Mark as Answer’ button if a post solves your problem! :)

    Some Random Thoughts

    Follow me on Twitter

    • Edited by
      Jason Tom ThomasEditor
      Friday, February 22, 2013 6:31 PM
    • Marked as answer by
      Elvis Long
      Monday, March 4, 2013 2:27 AM

Источник
  • Remove From My Forums

  • Question

  • hi

    I recently change excel 2013 preview to excel profesional 2013 but PowerPivot is missing, what do I have to do, It`s not in the COM add-ins list, I tried too many ways, somebody can help me.

Answers

  • Hi mlvmx,

    PowerPivot in Excel 2013 is an add-in you can use to perform powerful data analysis in Excel 2013. The add-in is available in Microsoft Office Professional Plus. It’s built-into Excel 2013 but is not enabled. Here’s how you enable PowerPivot before you
    use it for the first time.

    1. Go to File > Options >
      Add-Ins.
    2. In the Manage box, click COM Add-ins>
      Go.
    3. Check the Microsoft Office PowerPivot for Excel 2013 box, and then click
      OK. If you have other versions of the PowerPivot add-in installed, those versions are also listed in the COM Add-ins list. Be sure to select the PowerPivot add-in for Excel 2013.

    For more information, please see:
    http://office.microsoft.com/en-001/excel-help/start-powerpivot-in-excel-2013-add-in-HA102837097.aspx

    Regards,

    Elvis Long
    TechNet Community Support

    • Marked as answer by

      Monday, March 4, 2013 2:27 AM

  • Check this out — :(

    http://www.powerpivotpro.com/2013/02/hey-who-moved-my-powerpivot-2013-cheese/

    Update

    Find below the excerpt from MSFT employee

    «Hi all,

    We understand that this puts those of you who have less than ProPlus in a bad position where your previous Excel 2010 workbooks are concerned. You can’t use them in Excel 2013 without updating the data model, and you can’t update the data model without the
    add-in. If you know someone with ProPlus or an Enterprise SKU, you can always ask them to update the workbook and save it in 2013. From there, you should be able to use it.

    For basic PowerPivot functionality, you don’t need the add-in. So you can also recreate your PivotTables in Excel 2013 using the new data model. The key is to select «Add this data to the data model» when you create the pivottable from one of your
    data sources. Then you can import other tables, and use the «All» tab on the field list to add the other information. On either the Data tab or the PivotTable tools Analyze tab, you can create the relationships you need.

    Hope this helps!
    Anita»

    Cheers,
    Jason | www.SqlJason.com
    P.S. : Please click the ‘Mark as Answer’ button if a post solves your problem! :)

    Some Random Thoughts

    Follow me on Twitter

    • Edited by
      Jason Tom ThomasEditor
      Friday, February 22, 2013 6:31 PM
    • Marked as answer by
      Elvis Long
      Monday, March 4, 2013 2:27 AM

Источник
  • Remove From My Forums

  • Question

  • hi

    I recently change excel 2013 preview to excel profesional 2013 but PowerPivot is missing, what do I have to do, It`s not in the COM add-ins list, I tried too many ways, somebody can help me.

Answers

  • Hi mlvmx,

    PowerPivot in Excel 2013 is an add-in you can use to perform powerful data analysis in Excel 2013. The add-in is available in Microsoft Office Professional Plus. It’s built-into Excel 2013 but is not enabled. Here’s how you enable PowerPivot before you
    use it for the first time.

    1. Go to File > Options >
      Add-Ins.
    2. In the Manage box, click COM Add-ins>
      Go.
    3. Check the Microsoft Office PowerPivot for Excel 2013 box, and then click
      OK. If you have other versions of the PowerPivot add-in installed, those versions are also listed in the COM Add-ins list. Be sure to select the PowerPivot add-in for Excel 2013.

    For more information, please see:
    http://office.microsoft.com/en-001/excel-help/start-powerpivot-in-excel-2013-add-in-HA102837097.aspx

    Regards,

    Elvis Long
    TechNet Community Support

    • Marked as answer by

      Monday, March 4, 2013 2:27 AM

  • Check this out — :(

    http://www.powerpivotpro.com/2013/02/hey-who-moved-my-powerpivot-2013-cheese/

    Update

    Find below the excerpt from MSFT employee

    «Hi all,

    We understand that this puts those of you who have less than ProPlus in a bad position where your previous Excel 2010 workbooks are concerned. You can’t use them in Excel 2013 without updating the data model, and you can’t update the data model without the
    add-in. If you know someone with ProPlus or an Enterprise SKU, you can always ask them to update the workbook and save it in 2013. From there, you should be able to use it.

    For basic PowerPivot functionality, you don’t need the add-in. So you can also recreate your PivotTables in Excel 2013 using the new data model. The key is to select «Add this data to the data model» when you create the pivottable from one of your
    data sources. Then you can import other tables, and use the «All» tab on the field list to add the other information. On either the Data tab or the PivotTable tools Analyze tab, you can create the relationships you need.

    Hope this helps!
    Anita»

    Cheers,
    Jason | www.SqlJason.com
    P.S. : Please click the ‘Mark as Answer’ button if a post solves your problem! :)

    Some Random Thoughts

    Follow me on Twitter

    • Edited by
      Jason Tom ThomasEditor
      Friday, February 22, 2013 6:31 PM
    • Marked as answer by
      Elvis Long
      Monday, March 4, 2013 2:27 AM

Источник

Понравилась статья? Поделить с друзьями:

А вот еще интересные статьи:

  • Бюджетирование фот в excel
  • В excel 2010 нет поиска решений
  • В excel 2007 есть спарклайны
  • Бюджетирование строительной организации в excel
  • В excel 2010 нет надстроек

    • 0 0 голоса
    Рейтинг статьи
    Подписаться
    Уведомить о
    guest

    0 комментариев
    Старые
    Новые Популярные
    Межтекстовые Отзывы
    Посмотреть все комментарии