+ Reply to Thread
Results 1 to 6 of 6

Cell REF# Error

  1. #1
    Registered User
    Join Date
    03-21-2008
    Posts
    18

    Cell REF# Error

    I have an extensive excel sheet that has pages getting data from other pages within the document. It is about a 7 page document. All the pages pull data from the first page document. Sometimes when people insert data on page one, the other pages get a ref error in certain cells.
    EX:
    Sheet 1 cell A1- Hi
    Sheet 2 cell A1- =Sheet1!A1 (Thats what the formula is)
    Then when i look at cell A1 on sheet 2 it says #REF!

    Is there a way I can prevent this happening or someone tell me why this happens?

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    as you display it there i see no reason to display #ref
    sheet1 a1 looks to be referencing another cell

  3. #3
    Registered User
    Join Date
    03-21-2008
    Posts
    18
    I know, thats what I thought too, but sometimes it still comes up like that, I have even locked the sheet's so that no one can delete the rows or columns. Deleting the rows or the columns is the only way I believe that could happen, but in this case it cant happen because they are protected.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Post a workbook?

  5. #5
    Registered User
    Join Date
    03-21-2008
    Posts
    18
    Can't really post the document and its contents...

  6. #6
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    just post a row/column change data to something meaning-less

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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