+ Reply to Thread
Results 1 to 4 of 4

Refrence error

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    NY, USA
    MS-Off Ver
    Excel 2007
    Posts
    49

    Refrence error

    Hi everyone,
    I have got problem with REF error,
    just this morning i opened the file I work with everyday. The sheet January was fine, but the February had some REF ERRORS in it. This happened without me doing anything... Look, I know what REF ERROR is, but I don't know what happened to that February sheet that just this morning it went wrong!
    can u help? Could it be that my windows has got a problem?
    SEE THE ATTACHED FILE
    Attached Files Attached Files
    Last edited by a.janmohammadi; 03-09-2014 at 03:29 AM.

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Refrence error

    Hi,

    It's a bit hard to tell as there's no way to check what the Formula is supposed to be before the error occurred.

    The January sheets Formula is completely different to the February sheet.

    Can you explain what the Formulas in the February sheet were?

    Thanks
    Remember you are unique, like everyone else

  3. #3
    Registered User
    Join Date
    10-23-2012
    Location
    NY, USA
    MS-Off Ver
    Excel 2007
    Posts
    49

    Re: Refrence error

    I know the Formulas, the problem is I turned off the computer the day before, and the next day when I turn it on it is all REF ERROR!!!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Refrence error

    Without knowing what you were doing there, or what those formulas were referencing, its pretty much almost impossible to try and figure out what they should be And having te WB in another language and "back-to-front" doesnt help much either
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. refrence value
    By mak_pj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-27-2013, 04:22 PM
  2. [SOLVED] cell refrence
    By jeeper74 in forum Excel General
    Replies: 4
    Last Post: 02-16-2013, 11:55 AM
  3. [SOLVED] Circular refrence necessary or is there a better way help
    By sakecat in forum Excel General
    Replies: 2
    Last Post: 05-02-2012, 03:27 PM
  4. circular refrence error
    By coolkid78 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-31-2011, 08:02 PM
  5. Using one number to refrence another
    By pugsly8422 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1