Is there a way in Word to add a formula such as =sum(above) that will automatically update the total as numbers in the collumn are changed?

Currently, when I create a table in Word 2011 for Mac that has a column with numbers, I have to enter all of the numbers and then type in the sum formula in the cell below the numbers I created. If I change a number I have to reenter the formula at the bottom. In Excel once a formula is entered, it will automatically update the total whenever a number in the column cells referenced by the formula is changed. Am I missing something or is this a limitation of the table function in Word.

-------------Problems Reply------------

You shouldn't have to re-enter the formula but you do have to re-execute the field - select it, and use F9, or fn-F9, depending on your keyboard settings. Or select the entire document (cmd-A I think), then F9. If Mac OSX has reserved F9 you may need to set up a new shortcut key in Word.

Some field types in Word auto update, but not. { = } fields.

The other approach would be to embed or link an excel sheet - doing that involves a different set of problems, but the calculations should work in a familiar way.

I thought inserting a Excel spreadsheet involved the use of OLE (Object linking and embedded) and that was removed in modern version of Word excel. The last I remember OLE working in office was Office 2004.

As Peter explained, Formula fields are among the many field types which do not update automatically. Most types of field are expressly designed to behave that way in order to avoid undue performance degradation.

Another option for updating them, though... Right-click the field & choose the Update Field command. If the Table contains multiple calculations you can also select the table then right-click in it to update all at once.

Phillip:

Insert->Object... and choose Microsoft Excel Sheet.

It's like the earlier versions of WinWord, without in-place activation and AFAICR there is other nasty stuff to do with row/column count limitations.

What's not so great is that linking by doing Edit-Copy in Excel then Edit->Paste Special in Word doesn't work (not here, anyway).

But you can use Insert->Object->From File, check the Link to file option, and select the workbook does work - you end up with a LINK field that can be edited to select the worksheet+R1C1 range.

Similar stuff seems to be there in 2008.

> Most types of field are expressly designed to behave that way in order to avoid undue performance degradation.

Pity those ancient design decisions seem set never to change, and that the field language was set in stone when .docx came along.

Re: "What's not so great is that linking by doing Edit-Copy in Excel then Edit->Paste Special in Word doesn't work (not here, anyway)."

Odd... Works fine here.

As for the design, I can't say I disagree. It seems like it should be nothing more than a simple preference setting.

Thank you all for responding to my question. I appreciate the help and feedback!

> Odd... Works fine here.

Glad to hear it! Must be an error on my system.

Category:Office for Mac Views:8 Time:2013-10-30

Related post

Copyright (C) dskims.com, All Rights Reserved.

processed in 0.191 (s). 11 q(s)