none
Max entries allowed

    Question

  • Hello,

     

    I am working with a project that has 2,000 lines, but many columns. I recently received the error:

    "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, or consider dividing your project into subprojects to provide more space for tasks and resources."

    I have no reason to believe the file is corrupted. But I am wondering if Project is counting each entry as apart of the 1,048,000 limit. Ideally, I would like to not incorporate subprojects.

     

    Any thoughts?

    Thank you!

    Stephen

    Friday, January 06, 2012 4:37 PM

Answers

  • Stephen,

    You may not want to believe the file is corrupted but that's exactly what it sounds like. And no, Project does not treat each cell entry as part of the row limit.

    I suggest you go to the MVP website at, http://www.mvps.org/project/faqs.htm, and use one or more of the methods described in FAQ 43 - Handling Project file corruption and/or bloat.

    You should also make sure you have the latest updates installed for your version of Project. You can find them at, http://technet.microsoft.com/en-us/office/ee748587.

    Hope this helps.

    John

    Friday, January 06, 2012 4:52 PM

All replies

  • Stephen,

    You may not want to believe the file is corrupted but that's exactly what it sounds like. And no, Project does not treat each cell entry as part of the row limit.

    I suggest you go to the MVP website at, http://www.mvps.org/project/faqs.htm, and use one or more of the methods described in FAQ 43 - Handling Project file corruption and/or bloat.

    You should also make sure you have the latest updates installed for your version of Project. You can find them at, http://technet.microsoft.com/en-us/office/ee748587.

    Hope this helps.

    John

    Friday, January 06, 2012 4:52 PM
  • Yeah. Sadly this is true. The file was corrupted, but was able to be backed up successfully. Thank you for your suggestions and assistance, John.
    Friday, January 06, 2012 7:53 PM
  • Stephen,

    You're welcome and thanks for the feedback.

    John

    Friday, January 06, 2012 9:07 PM