- I used a bookmark reference named EQ2008 in a formula but the results gave the error message !EQ2008 Is Not In Table. Why?
- How can I write a formula so that Formula Plus Copy and Paste updates some cell references, while leaving others static?
- After updating data in a table, formulas that use bookmark names show errors when I recalculate. Why?
- I referred to a bookmark in my formula but the results are wrong and keep changing every time I recalculate. Why?
- What are the differences between the Word 2007 and earlier Word versions of your product?
- I used Financial Table Builder to build a table but some of the numbers are not lining up. Why Not?
- I noticed when I change some of the numbers in a table, the formula results didn't change. How do I update formulas?
- Is there an easy way to change formulas to text?
- I inserted a few rows in a Word table and now the links created using Table Link are pointing to the wrong cells. Why?
- Can I link to another Word document using Table Link?
- How can I edit a formula once it's been entered?
- I copied a formula. When I tried to paste the formula it didn't work. Why?
- I copied a formula using the Copy Table Formula feature. When I tried to paste the formula it didn't work. Why?
- I inserted a row in a table and now most of my formulas are wrong. Why?
If the bookmark name looks like it could be a cell address, Word assumes it is a cell address. In your example, Word is looking for a value in Column EQ, Row 2008 instead of the value contained in the bookmark named EQ2008. To prevent this, make sure your bookmark name cannot be misinterpreted as a cell address. Word will interpret a bookmark name as a cell address if the name begins with 1 or 2 letters followed by 1 to 5 numbers.
Bookmark the contents of a cell you want to remain static (ie, absolute) using Formula Builder Wizard's new Bookmarking feature. Once the bookmark is created, the bookmark name shows up in the left panel of the Formula Builder Wizard. Add the bookmark to the formula by double clicking its name. Add cell addresses to the formula you want Formula Plus Copy and Paste to update by double clicking the cell. For example, say you want to create a common size income statement. use the Formula Builder Wizard to bookmark sales data with a name like Sales2008. Write a formula that divides the cell address for sales by the bookmark name. The formula may look something like this:
=C3/Sales2008
The results of the above calculation would be 100%
Copy the formula and paste it down for cells next to the other income statement items using Formula Plus Copy and Paste. Formula Plus Copy and Pate will update the pasted formulas to something like this:
=C4/Sales2008
=C5/Sales2008
=C6/Sales2008
=C7/Sales2008
=C8/Sales2008
=C9/Sales2008
The pasted formula results should reflect their respective income statement items as a percentage of sales.
It's very easy to inadvertently delete a bookmark. When new data is typed in a cell whose contents are bookmarked, the bookmark may be deleted. When typing new data in a cell whose contents are bookmarked, make sure the new data is typed within the bookmark brackets. Bookmark brackets are only displayed when Word is configured to show bookmarks. When the "show bookmarks" option is selected in Word, bookmarks appear with brackets around the contents. For example, if the number 123 was bookmarked, it would appear as [123] when bookmarks are displayed. Of course, it may be easier to just recreate the bookmark using the Formula Builder Wizard.
The problem may be how the bookmark was created. When a bookmarked cell is used in a formula, the initial results may be accurate. However, once the formula is recalculated the results change and are inaccurate. It is important that bookmarks used in formulas are for the contents of an individual cell, and not the cell itself. We recommend that you use the Formula Builder Wizard to create the bookmark, and then add the bookmark to the formula by double-clicking the bookmark name in the left panel of the Wizard. Bookmarks created using the Formula Builder Wizard ensure that only the cell contents are bookmarked.
Formula Builder's Word 2007 versions support the Microsoft Office ribbon menu. The ribbon replaces Microsoft's traditional menu navigation system. Word 2007 also does not use toolbars as was the case with earlier versions.
Financial Table Builder is designed to construct financial tables suitable for most purposes. However, there are so many combinations of font types, font size, and decimal place combinations, that it’s not possible for Financial Table Builder to create a table that will work perfectly the first time in all situations. Correcting the alignment is fairly easy. First, make sure the ruler is displayed. Click to select the entire column where the numbers don't line up. Drag the decimal tab in the ruler until the numbers are aligned. The decimal tab in Word looks like an upside down T. Another alternative would be to experiment with different fonts and font sizes. A smaller font may solve the alignment problem.
Unlike Excel, formulas in Word do not automatically update when the data changes. Formula Builder has a Recalculate feature just for this purpose.
Formula Builder comes with a built in tool just for this purpose. You can convert formulas to text one cell at a time or the entire document at once using the Convert Formulas To Text feature.
Links created by Table Link are actually special formulas with references back to the table and cell that it is linked. When you insert rows in the table, the cell addresses of all rows below the inserted rows change. In an Excel spreadsheet, Excel automatically updates cell addresses in the affected formulas when rows or columns are inserted to preserve the intended cell references. Word, however, is not a spreadsheet. It doesn't have the built-in intelligence to adjust formulas for cell reference changes. The easiest way to correct this is to use Table Link to recreate the links.
No. Table Link allows you to link to Table cells within the same document only. The process of linking to another Word document is different. Consult Word help for more information.
Click on the cell you want to edit, and then click on the Formula Builder icon to open the wizard. The formula will appear in the formula window. You can make changes directly in the formula window.
Make sure you're using the Copy Table Formula feature to copy the formula, and the Paste Table Formula feature to paste it instead of the regular copy and paste functions provided in the core Word product. When you use Paste Table Formula it does not pull the copied formula from the clipboard. Instead, the Paste Table Formula feature accesses the formula from a special location in your computer's memory placed there when you use Copy Table Formula . Placing the contents of a copied formula on the clipboard would not allow Paste Table Formula to analyze and modify cell addresses in the formula as the needed to preserve relative cell references.
Make sure you use the Paste Table Formula feature instead of the regular paste function in the core Word product. When you use the Copy Table Formula feature it does not place the copied formula on the clipboard, so there's nothing there to paste. Instead, the formula is copied in your computer memory so cell references can be modified as needed using the Paste Table Formula feature.
This problem is a limitation of Microsoft Word. When you insert a column or row in an Excel spreadsheet, Excel automatically updates cell addresses in the affected formulas to preserve the intended cell references. Word, however, is not a spreadsheet. It doesn't have the built-in intelligence to adjust formulas for cell reference changes. However, by using Formula Builder and the Copy and Paste Table Formula features in the Toolkit, you can quickly and easily update the affected formulas.
