Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

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