How can i correct the formula?

January 30, 2013 at 05:56:43
Specs: Windows XP
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!

See More: How can i correct the formula?

Report •

January 30, 2013 at 06:12:51
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.


Report •

January 30, 2013 at 08:43:33
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.

Report •

Related Solutions

Ask Question