none
MS Project RRS feed

  • Question

  • Copied a project over to another computer. When trying to change the font color for 1 cell or multiple cells the following error generates:

    You have exceeded the maximum number if cells or Gantt bars that can be directly formatted in this view.

    You can only directly format up to 64,000 cells or Gantt bars in a viedw.

    Remove the direct formatting from one or more formattted cells in this view, and then try again.

    Click OK.

    How can this error be fixed?

    Thank you.

    Wednesday, May 1, 2013 8:17 PM

Answers

  • Hank62,

    First of all, do you have the latest service pack installed for the version of Project you are using? You can download updates at, http://technet.microsoft.com/en-us/office/ee748587.

    The obvious question is, does the file have a lot of field cell customization such as font colors, etc.? One simple thing to try is to first clear all formatting and start over with the minimum required formatting. Some remnants of previous formatting may be "gumming up the works", such that the file has corruption. If clearing all formatting doesn't help, try saving the file as XML and then re-opening in Project.

    John

    Wednesday, May 1, 2013 8:54 PM
  • Another way to reduce direct formatting is to edit the Text Styles. In Project 2010+ Format tab, Text Styles

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    Wednesday, May 1, 2013 9:23 PM
    Moderator

All replies

  • Hank62,

    First of all, do you have the latest service pack installed for the version of Project you are using? You can download updates at, http://technet.microsoft.com/en-us/office/ee748587.

    The obvious question is, does the file have a lot of field cell customization such as font colors, etc.? One simple thing to try is to first clear all formatting and start over with the minimum required formatting. Some remnants of previous formatting may be "gumming up the works", such that the file has corruption. If clearing all formatting doesn't help, try saving the file as XML and then re-opening in Project.

    John

    Wednesday, May 1, 2013 8:54 PM
  • Another way to reduce direct formatting is to edit the Text Styles. In Project 2010+ Format tab, Text Styles

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    Wednesday, May 1, 2013 9:23 PM
    Moderator