+ Reply to Thread
Results 1 to 8 of 8

Circular reference message displayed but no data appears

  1. #1
    Registered User
    Join Date
    07-20-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    4

    Circular reference message displayed but no data appears

    When I try to open an Excel file containing 247 kB of data I get a blank display (no grid, no data) and a note at the bottom: Ready Circular Reference H44. How can I recover my data which took a long while to develop? I am using Excel 2010 and all was OK when I last used the file. I also tried on another computer, with the same result, so this indicates that the program is not corrupted.

  2. #2
    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
    52,917

    Re: Circular reference message displayed but no data appears

    hi and welcome to the forum

    Circ Refs can be very tricky to find - just because it says the error is in H44, doesnt necessarily mean thats where it is.

    Its almost impossible to offer any help on solving something like this without taking a look at the file. If the file does not contain any sensitive data, could you upload it here?
    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

  3. #3
    Registered User
    Join Date
    07-20-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Circular reference message displayed but no data appears

    FDibbins,

    Thanks for your speedy response. However, the file does contain personal
    financial data. I hope I made it clear that nothing appears in the Excel
    window except the Microsoft menu bars - no cells, no data - and the error
    note at the bottom. If you can give any suggestions that I could try it
    would be much appreciated.

  4. #4
    Registered User
    Join Date
    07-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: Circular reference message displayed but no data appears

    Provide a cleaned up version of the xls that demonstrates the error.

  5. #5
    Registered User
    Join Date
    07-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: Circular reference message displayed but no data appears

    Provide a cleaned up version of the xls that demonstrates the error.

    edit: I re-read and it seems you probably can't do this... hmm...

  6. #6
    Registered User
    Join Date
    07-20-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Circular reference message displayed but no data appears

    Yes Mike65535. It is confidential data. What approach would you try?

  7. #7
    Registered User
    Join Date
    07-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: Circular reference message displayed but no data appears

    Have you tried the "Open and Repair" function?

  8. #8
    Registered User
    Join Date
    07-20-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Circular reference message displayed but no data appears

    Thanks for the suggestion, which is a new feature to me. I tried it but the message was "Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded" and I still don't have an openable file. Also, the program found a "previous" copy but this also failed to open. I will continue to explore this.

+ 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. Suppress Circular reference message
    By kevie192 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-20-2009, 05:32 AM
  2. Replies: 1
    Last Post: 08-21-2007, 07:22 PM
  3. Worksheet_Change function and circular reference error message
    By nicole_2007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2007, 07:35 AM
  4. Replies: 2
    Last Post: 04-02-2006, 07:00 PM
  5. Getting rid of a circular reference error message
    By sharkfoot in forum Excel General
    Replies: 9
    Last Post: 03-26-2006, 03:00 PM

Tags for this Thread

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