Forum Discussion
Task Sorting Bug Microsoft Project 2016
Not sure if this will help but go to View > Data group > Sort and make sure it is set to "sort by" ID, ascending. Then hit the Reset and Sort buttons. Also make sure the "Permanently renumber..." is unchecked and "Keep outline..." is checked. Now, save the file and close out of Project. Restart Project and open the file. Is it sorted as you expect?
Here's something else that might be causing the sort. Does the file have an Event macro that does something when the file is closed or opened? You won't see either of those macros listed if you go to View > Macros or even Developer > Code group > view macros. But you can see either by going to Developer > Code group > Visual Basic and then hit the Project Explorer icon in the VBE window that appears. Double click on the "ThisProject (xxxx)" for the file.
- 5hane_222Mar 24, 2021Copper Contributor
John-project Unfortunately this did not resolve the sorting that has happened. I've tried a few variations of what you have suggested too. The Project has also filled out %complete tasks too which are not complete, assigned resource to tasks etc. its all very strange.
I've checked the Marcos and VB and nothing there either.
I am going to put a fresh install of Project on and cut my losses with this Project and put it in the bin. Ill see if I have the same error again.
- John-projectMar 24, 2021Silver ContributorShane_222,
It almost sounds like someone else has access to your file and is messing with it, have you considered that?
I seriously doubt the issue is with Project itself, I suspect if anything, the file itself if the problem so rebuilding it will likely solve the problem. One thing you might try first is to save the file as XML. then re-open the XML file in Project.
Good luck
John- 5hane_222Mar 24, 2021Copper ContributorIt almost does seem like that, but it is actually saved on my HDD and not on a server.
I guessed that the file had become corrupt for what ever reason but would rather understand how it happened as to avoid it happening again.