microsoft excel 2011 formula reference another sheet

These aren't all the places that there could be errors Excel is really good at letting errors exist in lots of places. Look at each name in the Name Manager dialog box (Formulas tab, click the Name Manager tool), making sure that whatever is in the Refers To column doesn't include any error indications. You should also take a look at any named ranges defined in your workbook. Inspect anything that is found to see if it is an error or not. Make sure you tell Excel to do its searching within Formulas. Just press Ctrl+F to display the Find tab of the Find and Replace dialog box, then search for the # character. You could also use the Find tool to look for possible errors. You can then use the Tab key to move amongst any cells that Excel selects. (Yes, you need to do these steps for each worksheet in the workbook.) Use the Go To Special dialog box (press F5 and choose Special) to choose to go to only the cells that contain errors. The first is in the formulas that are on the worksheets. There are several places you can start to look. Tracking down invalid references can be frustrating. How can I find the errant formula? I do not observe any problems in the display of information on my reports.

Joel noted that when he closes a workbook that has thousands of formulas in it he is getting this message lately: 'A formula in this worksheet contains one or more invalid references.' Joel wonders how he can know which of the seven worksheets in this workbook is being referred to.

Microsoft excel 2011 formula reference another sheet