Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
I agree, the Mathcad approach is light years better than Excel and would have complete associativity with the Pro/E CAD model and handle units. Another option is to evaluate your free bodies in Pro/Mechanisms (MDX/MDO). If the system you need to perform a free-body on is a mechanism to begin with, this would be the best method. Static analyses can be performed as well.