Edit Default Layout

Question

I would like to make setting changes for my pivot tables which requires access to edit default layout.  But its grayed out.  How to I access this field?

Thanks, AL

Answer 1

Thank you for your response.  But I resolved my problem with a simple fix that often goes unnoticed.  All I did was update my excel application.  This procedure often goes overlooked because you don't think of doing this.  You may want to add this to the list of fixes for this type problem.

But anyway, thank you for you help.

Answer 2

Hello AL,

Thank you for taking the time to reply and providing us an update. We are pleased to know that you have resolved the problem by updating the Excel application. We will take note of your feedback. Rest assured that we will continuously strive to improve our products and deliver our services better.

If you have any further concerns, please feel free to contact us back. We're happy to assist you again.

Answer 3

Hello AL,

It is possible that you're trying to edit a protected sheet. We'd like to assist you better on your concern, and therefore, we recommend using the Steps Recorder tool, and send the .zip file to us an attachment to your next message. This will enable us to have a better look at what you're trying to work on.

To send a private message:

1. In my previous response, click Advanced Tools.
2. Click Initiate Private Message.
3. On the message editor, click Choose File.
4. Browse the file and click Open.
5. Compose a message (optional), then click Send.

To notify us and have us get back to you, simply reply to this post.