How do I validate the data in a source file of MS Project?

[crazmeister]

I have a MS Project file which did not shut down correctly and is now coming
up with an error message when you try open the file. The message reads as
follows: 'The operation cannot be completed because the source file contains
invalid project data or the total number of rows would exceed the limit of
1,048,000 rows in a project. Validate the data in the source file, insert
fewer rows, delete some rows, or consider dividing your project into
subprojects to provide more space for tasks and resources.'
Is there any way to validate the information contained within the file and
recover it as there are definately not the number of tasks listed as being
the problem. I cannot currently open the file to try identify which tasks are
causing the error to be generated, although I did get a message before it
shut down to say that the information could not be saved as it was an
incompatible version!

 

[Rod Gill]

Hi,

Try the corrective methods at:
http://project.mvps.org/faqs.htm#Handling_project_file_corruption_and/or_bloat

Try also pressing Ctrl+End and look at the last task ID. Sometimes with a
corruption there may be many blank rows followed by 1 "extra" Task that can
be deleted. Obviously take some copies before experimenting!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com