none
Microsoft Project 2010 formula errors RRS feed

  • Question

  • Created a simple formula to multiply one column with the next. The formula being Val(Number1*Number2) When I originally created the formula it worked great. After some more customizing of the project file that I was working on, the formula no longer works.

    For troubleshooting steps, I copied the list of tasks to a new project file and created new columns thinking that I had changed something in the previous columns. Still receive the same results. Also took the Val () out of the formula but that didn't fix it either. Hitting F9 or going to the formula and clicking okay will make the formula calculate but it would be preferable if it calculated automatically like it orginally did.

    Any thoughts or suggestions would be greatly appreciated.

    Thanks,

    Michele

    Thursday, August 1, 2013 7:20 PM

All replies

  • Michele,

    Did the "customizing" effort result in auto-calculate being turned off, because that's exactly how it acting? Check it under File/Options/Schedule group.

    Hope this helps.

    John

    Thursday, August 1, 2013 8:13 PM