Strange error about invalid project data.

[monstadunk]

I am working on a company project that has many links, both inside of its
self and to Excel. When I try to pdate the links I get the following error:

"The operation cannot complete because the source file contains invalid
project data or the total number of rows would excede the limit of 1,0480,000
rows in a project."

I know that the error has to be comming from some sort of invalid project
data because I actaully only have 3500 rows.

I have taken the project over from someone else. That person made a lot of
wierd categories because he didn't know what all the other categories do. The
ones that I think are causing a problem are the custom number categories
called Estimated Quantity (same thing as work) and Quantity Completed (same
as actual work). Then he tied those two in to another custom number category
ambiguously named Number 3 and linked Number 3 to % Complete. The only reason
I can see for him to do this would be to get rid of the "hrs." label in the
Work category. The work is being tracked in Welding Inches, not hours.

Is there anyway I can remove the "hrs." label from the Work categories? That
might fix my problem, as well as reduce the number of links on this project.
As it is, it takes a few minutes to load on some of the slower machines,
longer if the server traffic is high.

Thanks.

 

[Rod Gill]

If you have links to another file (in this case Excel), has your project
file or the Excel file ever been renamed, moved or over-written? If so then
it is likely that you have a file corruption. The only way to unwind the
corruption is to delete all inter-file links then save both files before
re-building them.

Even if you haven't done any of these risky things, there may still have
been a corruption. Links are risky and it is safer to use file exports or
VBA code to copy data than have links.

To get rid of the Hrs from the Work column, insert the Text1 or Number1
custom field. Create a formula [Work]/60 (work is stored as a number of
minutes so /60 calculates number of hours).

Just to confirm, your categories are in fact columns of data in a View?
--

Rod Gill
Microsoft MVP for Project

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

 

[Jim Aksel]

In a spare number column, Number1 (example) you can apply a formula set equal
to [Work]. The value displayed will be purely numeric and will be in
minutes. There will be no label of units such as hours.
The text column will work in a similar manner.

I doubt the error you illude to is coming from custom data calcuations in
the number fields. More than likely you have poor cross references into your
Excel data. You will need to examine the mapping relationships between your
Excel columns and names with the Project Data.

--
If this post was helpful, please consider rating it.

Jim

Check out my new blog for more information:
http://www.msprojectblog.com

 

[monstadunk]

In a spare number column, Number1 (example) you can apply a formula set equal
to [Work]. The value displayed will be purely numeric and will be in
minutes. There will be no label of units such as hours.
The text column will work in a similar manner.

I doubt the error you illude to is coming from custom data calcuations in
the number fields. More than likely you have poor cross references into your
Excel data. You will need to examine the mapping relationships between your
Excel columns and names with the Project Data.

--
If this post was helpful, please consider rating it.

Jim

Check out my new blog for more information:
http://www.msprojectblog.com

On that note, can I add a custom unit type to a custom field? For example;
As I said, we deal a lot with inches and feet. Can I create a custom field
that I can enter information to and have it display # inches? And what about
percentages? I have not been able to make a custom field display percentages.
I would be able to save myself some time if I could create a custom % field
that would take the Number 3 category and add it to % Complete. I imagine it
would look something like this;

([% Complete] + [Numer 3])%

I tried this, but it didn't work.

 

[Jan De Messemaeker]

Hi,

You can add % or inch to a value only in a text field
So suppose you have your "naked" value in the number3 field, you could in
Text3 put the formula
[Number3] & " Inch"

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

In a spare number column, Number1 (example) you can apply a formula set
equal
to [Work]. The value displayed will be purely numeric and will be in
minutes. There will be no label of units such as hours.
The text column will work in a similar manner.

I doubt the error you illude to is coming from custom data calcuations in
the number fields. More than likely you have poor cross references into
your
Excel data. You will need to examine the mapping relationships between
your
Excel columns and names with the Project Data.

--
If this post was helpful, please consider rating it.

Jim

Check out my new blog for more information:
http://www.msprojectblog.com

On that note, can I add a custom unit type to a custom field? For example;
As I said, we deal a lot with inches and feet. Can I create a custom field
that I can enter information to and have it display # inches? And what
about
percentages? I have not been able to make a custom field display
percentages.
I would be able to save myself some time if I could create a custom %
field
that would take the Number 3 category and add it to % Complete. I imagine
it
would look something like this;

([% Complete] + [Numer 3])%

I tried this, but it didn't work.