Microsoft Excel Interview Questions and Answers
Question: What you could do to stop the pivot table from loosing the column width upon refreshing?Answer:Format loss in pivot table can be stopped simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable “ Auto Format” option. |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is Microsoft Excel?
- What is ribbon?
- How can I hide or show the ribbon?
- How can you wrap the text within a cell?
- Is it possible to prevent someone from copying the cell from your worksheet?