File bloat !

Microsoft Project

    Sponsored Links


  • 1. Outline rollups
    I have created an outline code in 2007 for G/L codes and need to get a rollup on each level. My outline code works as follows: 4-digit number 3-digit letter 2-digit number My code mask is working fine and I can assign the appropriate G/L code to each task. When I go to create a rollup, I have created a custom grouping with 3 levels, all the field G/L. On the highest level I tell it to group in level 1, on the 2nd level I tell it to group on level 2, and on the third level I leave it on on each value. The result I get is No value on the top level and unintelligible characters in the summary rows for level 2 and 3. I'm trying to sum up cost and work by the detailed part of the G/L code as well as the higher parts of the code. What am I doing incorrectly? Thanks in advance for any help! r/Jon
  • 2. Microsoft Project 2007 - Visual report - Cash Flow - Excel busy
    When i create a cash-flow report on pc's with microsoft Project 2007 and excel 2003 it works good on some pc's and on other pc's i get an errror (Excel is busy) and no cash-flow report will be shown. On all PC's MS Project is installed including SP1 and the infrastructure update and Excel 2003 is installed including SP3. (All software dutch versions). What can be the problem? Thanks for help, Gerjan Mollenhorst RH Business Solutions
  • 3. valuable template
    i am looking for a Template or any work around to create a report of my project with Resource on the top bar. For Example: Task Duration ManHours PM[50%] Dev1 Dev2 Dev3 QA1 QA2 QA3 Start End ----------------------------------------------------------------- TestProject - Totals 75 days 1,740 300 480 400 320 80 80 80 4/14/2009 7/31/2009 ----------------------------------------------------------------- 70 days 560 480 80 4/27/2009 7/31/2009 Analysis & Identifying Major Screen Layouts 5 days 40 4/27/2009 5/1/2009 - development 45 days 360 5/4/2009 7/3/2009 WSP Server - development 10 days 80 7/6/2009 7/17/2009 QA - Unit / Integration Testing 10 days 80 7/20/2009 7/31/2009 WM5 - TestProject Client Application 60 days 480 400 80 4/20/2009 7/10/2009 WM5 Client App - development 50 days 400 4/20/2009 6/26/2009 QA - WM5 Unit / Integration Testing 10 days 80 6/29/2009 7/10/2009 BlackBerry - TestProject Client Application 50 days 400 320 80 4/20/2009 6/26/2009 WM5 Client App - development 40 days 320 4/20/2009 6/12/2009 QA - BlackBerry Unit / Integration Testing 10 days 80 6/15/2009 6/26/2009
  • 4. Cannot connect to Project Server 2003 from Project Professional 20
    When I am trying to connect MS Project Server 2003 from a MS Project Professional 2003.I get a dailog box displaying "Cannot Connect". Project was unable to establish a connection with the selected project server. What should i do.I have created a Project server account. Thanks in advance
  • 5. Calculating project completion %
    This is probably more about project management in general, then MS Project specific. But somebody please help me here or atleast guide me to a place/resource where i can find the answers... ... Here is the problem: Lets say I got a project consisting of 5 tasks with estimated work and status as shown below: T1 - 5hrs - 100% complete - Actual work logged is 5hrs T2 - 10hrs - 100% complete - Actual work logged is 10hrs T3 - 10hrs T4 - 20hrs T5 - 5hrs - 100% complete - Actual work logged is 5hrs So, percentage work complete is: 20/50 * 100 = 40% Now lets think of a slightly different scenario: We still got the 5 tasks above but with different Actual values: T1 - 5hrs - 100% complete - Actual work logged is 10hrs T2 - 10hrs - 100% complete - Actual work logged is 20hrs T3 - 10hrs T4 - 20hrs T5 - 5hrs - 100% complete - Actual work logged is 10hrs WHAT I badly NEED is a mathematical formula that can be used to calculate percentage work completion in such scenarios. Somebody please, please help me. I would have posted it somewhere else if i knew of any other place where as knowledgeable responses are received as promptly as they are here. Thank you.

File bloat !

Postby Adrian » Sat, 30 Jun 2007 15:41:52 GMT

I recently purchased MS Project 2007.  I continually crash when trying to 
print large project files (300 line).  I watch the file being sent ot the 
printer and it grows to 25 MD sometimes.

Why is that.  When my partner prints the same file in MS Project 2003 it is 
about 800 KB.

Why so bloated in 2007?

RE: File bloat !

Postby SmltIEFrc2Vs » Thu, 05 Jul 2007 06:34:02 GMT

Although I cannot explain the bloat, here is what I tried to fix it when it 
happened to me:

1. Save the file as XML and then reopen it, save as a new file.
2. Save it to Project 2003 format, open it in 2003 and immediately save it 
as mpd file.  Then reopen the mpd file and save as.

I had better success with method 2, but I still ended up recreating the thing.
If this post was helpful, please consider rating it.

It''s software; it''s not allowed to win.

Visit  http://www.**--****.com/ 
about Microsoft Project

Similar Threads:

1.MS Project 2003 VBA "File Bloat"?

2.Treating File Bloat in Project 2007

MS Project: File Bloat Observations
We have had a problem with file bloat in 2007, that were not fixed by the 
approaches in the FAQ doco.
We have done some research/ tried a few approaches, and the following 
summarises our results.
We would be interested in comments. feedback.

General observations :
If a schedule is long enough, and with enough use, it will more than likely 
become loatedi.e. larger in file size than is necessary to store all 
the schedule data. Generally, it also seems to be more prone to crashes than 
an ordinary schedule. When a substantial number of schedules are in use, file 
bloat can pose a significant problem, because 
-hard drive space is consumed unnecessarily
-bloated schedules crash more often than normal
-MS Project is slower when working with bloated schedules, and 
-opening master files becomes slower and more crash prone

We have found that the best method to counter file bloat involves generating 
.mpd files, which can only be done using MS Project 2003. Assuming there is a 
copy of MS Project 2003 on hand, the method we use to nbloata schedule is:
-Open the bloated schedule in MS Project 2007
-Save the schedule as an MS Project 2003 file (using a different filename*)
-Open the bloated schedule in MS Project 2003
-Generate an MS Project database (.mpd) file from the schedule
-Open the .mpd file in MS Project 2007, and save the resulting schedule as a 
new .mpp (do not overwrite another .mpp, the resulting schedule must be saved 
as an entirely new file*)

* When saving a schedule by overwriting another .mpp, the resulting file 
tends to be highly bloated, sometimes more than twice its original size. 
Because of this, we suspect that when an overwrite is performed, MS Project 
stores both the old, redundant from the file being overwritten, and the 
current data in the schedule being saved, into the resultant .mpp file. As 
such, when saving schedules for the purpose of nbloatingthem, it is 
necessary to use unique filenames on each save.

 Notes on conversion between MS Project 2007/2003/MPD formats
  There were two things that were lost as a result of the conversions 
between these formats:
-Names of exceptions in calendars e.g. ood Fridaybecomes nnamed 
although the actual exception is still present in the calendar.
-Shading of cells in tables

This is because neither of these features were available in MS Project 2003.

However besides that, on inspection it appears none of the tasks, resources, 
dates, custom fields, views, and settings, project labels (i.e. author, 
manager, etc), customised calendars, task types or task constraints are 
affected by the conversions between these formats.  However, we did not 
inspect financial settings, such as currencies or rates, because we do were 
not using these features in the files we treated.

We would appreciate any comments/ additional info..

Such as:
-Is there a delete/define/restore or defrag utility available for MS Project 
-Is there a method to de-bloat files that does not require an older version 
of the software to be loaded (requiring a separate machine)!
-Why isn't .mpd format creation included in 2007?


3.File 'Bloat' is becoming a showstopper

In article < XXXX@XXXXX.COM >,
 Geoff < XXXX@XXXXX.COM > wrote:

> First post on this site from me.
> I'm using Project 2003 Standard and have a file that is c2500 lines and 
> weighs in at about 31MB. I've been running monthly updates on copies of this 
> for about 2 years now. After a heavy session of re-baseling this month I 
> noted that the file had grown to about 91MB. This is a bit unmanageable.
> I trawled through other posts and found the "Project File Size is HUGE 
> suddenly" post from December 2005 - sounded horribly similar to my 
> predicament. The threads ended but I'm not sure that a solution was found. 
> I've attempted the mpd save fix from FAQ 43 but without success - it wouldn't 
> save on my machine because of insufficient virtual memory and I'll need to 
> get admin help to increase this.
> I then reverted back to the pre re-baselining 31MB file and did a limited 
> amount of re-baselining. I saved the resulting 33MB file to an mpd and the 
> size of this surprised me at 276MB. I wasn't surprised therefore that the 
> 91MB file was difficult to save as an mpd if that's the ratio of growth that 
> occurs.
> Can anyone help me prevent this file size growth and/or point me at a 
> utility to help me housekeep the 91MB file to make it smaller.
> The start of the project update cycle is approaching rapidly........
> Many thanks.

I'm assuming that by "c2500" you mean your file has 2500 tasks. A file 
that size shouldn't even be 1M unless you have a whole lot of links or 

First of all some advice. Are you doing a straight Save each time? If 
so, that may be one reason the file keeps growing. I always use Save As 
exclusively and I've never had a file bloat problem.

You still may need more memory to get this to work but here is another 
method for getting the file size down.
1. Open a new blank file.
2. Go to Insert/Project and insert your bloated file.
3. Select the insertion point summary line of the subproject
4. Go to Project/Task Information/Advanced tab and uncheck the "link to 

You should now have a cleaned up version of the file. Do a Save As, 
close it and then take a look at how big it is.

Hope this helps.
Project MVP

4.A different file size bloat problem

A user of Project 2003, SP3 had a 1Mb .mpp file.

A few of the Views were updated via Page Setup to add logos into the
printed header.

The pictures inserted were tiny .JPGs (about 10k)

New .mpp file size 8Mb, presumably because pictures stored internally
as BMPs (?).

The .mpp file will still zip down to 1Mb, but preference is not to
need to.

Anyone know of any workround ?

EG: would pictures stored as .WMF or .PNG have same problem ?


5.Fixing Bloated files

Hi All,
We recently experienced some 'bloating' of two published project files. 
I've read the white paper on 'cleaning' bloated files.  In our case 
exporting the file to XML and re-opening it should solve it.  However, I am 
unclear about handing the server side of things.  What are the step involved 
when the file is published?  Do I delete that server copy and replace it 
with this new and improved file?  Ifso, what happens to the previously 
published assignments? Specifically will any of the users notice the 
deletion and re-publication?


6. Bloat

7. Bloated / Slow global.mpt

8. Token bloat

Return to Microsoft Project


Who is online

Users browsing this forum: No registered users and 24 guest