Q&A
| Q1: | I built a linking formula to link data on several sheets, Budget 2003, Budget 2004, and Budget 2005. Excel informed me that my formula is wrong. What next? |
| A1: | When the sheet name contains spaces, such as Budget 2003, you need to place single quotation marks around it when you are making sheet references. |
| Q2: | Why didn't Excel update the data in my linked workbooks? |
| A2: | If both the source and dependent workbooks are open, Excel updates the links automatically. The Update Now button in the Links dialog box is available only if the source workbook is not already open and if any linked formulas have been changed since the last update. Choose Edit, Links and then click the Update Values button in the Edit Links dialog box to update the data in ... |
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
