I have added a refresh button on the attached workbook to be able to refresh the pivot table from any data entered into the Project_Data tab. I have manually sorted the pivot table, as I stuggling to get the correct sort what I wanted.
Once any updated data is entered into the Project_Data tab and I refresh the Pivot table, it autimatically sort itself and change the Gantt chart layout.
How do I keep my "sort" layout?
Bookmarks