i am working on a excel sheet and i was almost finished unitl i got to the last month. i entered a formula and then a box came up titled updated values and it had other files there. when i picked a file and then the month, it came up as a error #REF!. Ive checked the whole excel sheet and i cant find a mistake. Im confused!

There is a mistake other wise you wouldn't be get #REf You need to trace the dependencies and to cells with the error and you will come eventually find the error. You can all use the built in error trace to track down where the error occurs.

Tools/Formual Editing/Trace Error

At least this is one Excel 2002 On later versions it may be different but the same principle applies.

Stuart

We can't offer much help without knowing what your formula looks like and how you are using it. Since can't see your spreadsheet from where we are sitting, nor can we read minds, you need to provide as much detail as you can so that we can understand your situation.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History