O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required