Locking column width - upon refresh of PivotTable

P

pepenacho

Hello:

I have a PivotTable, which I use for a report. It contains a lot of data and
I'm trying to make it a bit bigger.

Each time I refresh, the column headings force the columns to widen-up
(where I previously wrapped the text to crunch the width of the column).

I'd hate to keep readjusting. Is there a way to set the width of the column
and row to a specific setting - permanently??

Thanks
Pepe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot tables and column widths 1
When refreshed, some Pivot Table columns retain formatting, some d 0
The PivotTable field name is not valid (error) 1
Different column widths? 1
Working on birthday "book" for my wife and having layout/editing trouble 0
Column width - Data connected to Database 0
Pivot Table Column Widths 2
Column width of Pivot Table data goes back to default when data refreshed 5

Top