danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
Something that I've run into in the past week or two.
The column widths on my pivot table are set not to auto align. In the past, when I double click in it, it would open a new sheet called "Sheet1" or something.
Now when I double click on it:
- it opens a new sheet called "Detail1".
- the column widths of the pivot table auto aligns
Any idea on how to stop the auto alignment of the column widths of the pivot table when double clicking in it?
My Excel version: Version 2404 (Build 17531.20152) Microsoft 365
A found a similar post below but no solutions yet:
The column widths on my pivot table are set not to auto align. In the past, when I double click in it, it would open a new sheet called "Sheet1" or something.
Now when I double click on it:
- it opens a new sheet called "Detail1".
- the column widths of the pivot table auto aligns
Any idea on how to stop the auto alignment of the column widths of the pivot table when double clicking in it?
My Excel version: Version 2404 (Build 17531.20152) Microsoft 365
A found a similar post below but no solutions yet: