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:When I enter a formula, I get a #NAME? error. What does it mean?
A1: The most likely cause for this error is that you're entering the range name incorrectly. Try using the Insert, Name, Paste command to ensure the range name in your formula is correct.
Q2:I created a formula that referenced a workbook file that was created by one of my co-workers. Today Excel says it can't find the file my colleague created. What do I do?
A2: Check to see whether your co-worker deleted, moved, or renamed the file. The formula won't work if the file is gone or moved. If the file has a new name or a new location, update your formula accordingly.
Q3:I work on a laptop connected to a network that I take home at night. Why do formulas that work in the office ...

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