Microsoft Project 2010 issue

Hi, I am having a really strange issue, basically, since Thursday 2 users are struggling to open a project document correctly but one user is able to open the document correctly and use it fine. They are all running the same versions of office and patched equally. I have tried uninstalling, ccleaning and reinstalling project on one of the faulty machines but still having no luck at all. It is a really difficult situation to explain but basically the drop-down options aren't working for one column. Now it wouldn't be a problem to recreate the options, we tried this but after closing and opening the document a couple more times the problem returned on 2 of the 3 machines that use the file. I have tried restoring a couple of versions of the document, one from Thursday when it was working and also I tried as a test restoring the oldest version of the document in shadow copy but they both had the same problem. If anyone could help it would be most appreciated. I have also attached 2 screenshots to try and explain the situation a bit better.

Best regards,

Dan
not-working.PNG
working.PNG
PurpleJellyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Richard DanekeTrainerCommented:
The one that works is the standard task type drop down.
The one that isn't working is a custom field.

Right-click on the field name that is not working and choose Custom Fields.
There should be a lookup to provide the answers you are trying to select.
Either the lookup is not working or the values have been deleted.
0
BembiCEOCommented:
If I understand your problem in the right way, you want to say, that the project file (*.mpp) opens on one machine and the lookup table shows fine, and on other machines, the same project file doesn,t show the lookup values which are visible on the working machine, right?

And I also assume, it is a local mpp file (so not project server). Right?

For local files, all values are stores in the file itself, that means if you crate custom fields in your project file, it should be visible on any machine (same version, same patch level assumed - to exclude other issues).

Beside the file, you can create content in the global.mpt, what is the master template for all new projects. Nevertheless it should not interference (i.e. such a field is defined in the global as well as in the file itself), I would keep it in mind.

What I would do now is the following.
1.) Save the project file in XLM file format and have a look into the XML file (i.e with Office XML Notepad 2007 or any other XML viewer). This gives you a clue, if the file itself has a problem. You should search inside the file for some cryptic content. Dependent from the version you used for creating the file, it can happen that you took over some crap from earlier versions.

2.) It can be a try to replace / recreate the global.mpt file on the machine. You can just delete the file (save a copy). Project will recreate the fle with default at the next start, but all local settings will be away. You can also copy a global.mpt from one machine to another for testing. Resinstalling doesn't replace the global.mpt if it is there before.

If you find left over files from older MS Project Versions (i.e. global.mpt from 2007) you can delete them completely. During the first start of MS Project, settings from earlier version are taken over (there is a dialog during the fist start) and you can import old crap again and again.

3.) You can try to create a new file, create a view which is identical with the view of the old file (the column) and copy the task from the old one to the new one. Don't copy whole lines (what copies all the invisible fields), copy only the fields you need. Maybe you have the copy the resources first and to create the custom fields and lookup values.

Also you may have a look into the MS Project Organizer, if you see something strange there. The organizer you can also use to copy content from one file to another.

After option 2 and 3 you can check, if the problem still exists. This way you find out, if the global template is possibly corrupt or if the project file has a problem.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.