I have a spreadsheet that is currently shared by about a dozen people/
I have two quick questions:
I am often finding a temp version of the file (beginning with ~$) created in the directory, and it stays there well after the users are out of the file.
This isn't s problem for me, because I...
For the life of me I can't find where I can set the Pivot Table's column size for just xlColumnField and I've spent far too much time on this simple little thing. grrrr
I have several macros that auto generate pivot tables based upon criteria. I want the Autofit columns to be turned off after...
this is frustrating...every I make a selection in one of the Page Fields the column widths change and the pivot table is not viewable on a single page. I have tried checking the box next to 'Preserve Formatting' in the Table Options view, but that does not work.
suggestions appreciated...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.