locked
formula in word not working RRS feed

  • Question

  • We have a word document with an embedded table. In this table we have one cell being calculated from other cells, another cell into which a value is being entered, and a third cell that is simply adding the calculated cell to the input cell. The result is inconsistent and incorrect. Has anyone has any similiar issues?
    Tuesday, April 26, 2011 9:34 PM

Answers

All replies

  • Hi Joe,

    Without more details about the table structure, the actual formulae bing used, etc, it's hard to say. Are the cells with the formulae all being updated following the data changes? Do any of the formulae use SUM(ABOVE) for ranges spanning empty/text cells?

    You might also find some useful pointers in my Microsoft Word Field Maths Tutorial, available at:
    http://lounge.windowssecrets.com/index.php?showtopic=365442
    or
    http://www.gmayor.com/downloads.htm#Third_party


    Cheers
    Paul Edstein
    [MS MVP - Word]
    • Marked as answer by Harry Yuan Tuesday, May 3, 2011 2:04 AM
    Wednesday, April 27, 2011 3:01 AM
  •  

    Hi,

     

    I am writing to see how everything is going with this issue. Is the problem resolved? If there is anything I can do for you, please feel free to let me know.

     

    Best Regards,

     

    Harry  Yuan

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com   

    Wednesday, April 27, 2011 5:19 AM
  •  

    Hi,

     

    As I have not heard from you for several days. I will go ahead and close this thread. If this issue is not resolved or you have any questions, please feel free to reply to us and this thread will be re-opened.

     

    Best Regards,

     

    Harry Yuan

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com   

    Tuesday, May 3, 2011 2:04 AM