Share via

Excel 2016 - "Edit Default Layout" not there

Anonymous
2017-06-29T16:26:51+00:00

I am using Windows 10 with Excel 2016 Professional Plus MSO 16.0.4549.1000, 64-bit. (This is not a Home Program version)

Apparently there is an option in Excel to change the Edit Default Layout for Pivot tables (File, Options, Advanced, Data)

but in my Excel this Option is missing.

How can I make this available?

Normal Excel:

My Excel Options:

 

**Post moved / split by the moderator to the appropriate forum category / another thread

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

15 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-12-18T22:54:00+00:00

    Unfortunately, the Default PivotTable option is an Office 365 subscriber feature, so it's not going to show up in your perpetual version.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2017-09-07T08:08:39+00:00

    Did you get this sorted, I am having the same issue

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2017-07-29T00:48:46+00:00

    Has anyone found an answer to this.  I have the exact same issue.  I want to set my default pivot table, but I do NOT have the option under data.  Was this option remove with Excel 2016?

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  4. Anonymous
    2017-07-08T07:29:27+00:00

    Ok, I went through your suggested steps and did a repair of Office.

    Of course, nothing has changed. The Excel option is still not available.

    Thank you for waisting an hour of my time.

    Any other suggestions?

    Regards

    Roni

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2017-07-06T08:41:13+00:00

    Hi Anna

    Thank you for your instructions.

    Before I go through them can you please confirm that the"Edit Default Layout" Option for Pivot tables is really available in the Version of Excel I am using.

    I somehow suspect that this Option may only be available in Excel 365.

    Regards

    Roni Wullschleger

    I am using the following Version of Excel:

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments