+ Reply to Thread
Results 1 to 4 of 4

Circular reference issue and External data

  1. #1
    Registered User
    Join Date
    02-16-2012
    Location
    london,england
    MS-Off Ver
    Excel 2010
    Posts
    38

    Circular reference issue and External data

    Hi,

    I have a timesheet spreadsheet, this has a circular reference, that I cant seem to find aand some external data too.

    any ideas n the attached sheet


    cheers in advance

    Keith

  2. #2
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Circular reference issue and External data

    Hi Keith

    Have you tried the error checking on the formulas tab.

  3. #3
    Registered User
    Join Date
    02-16-2012
    Location
    london,england
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Circular reference issue and External data

    Yes but it gives me $u$7.

    and i dont understand i have looked in U7, but there does not seem to be a circular reference, unless im missing something

  4. #4
    Registered User
    Join Date
    02-16-2012
    Location
    london,england
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Circular reference issue and External data

    Figured it out, cheers.
    I was too close to the problem so took the dog out and came back and had a look and realised I had code pasted into some cells twice, although not sure why i wasnt getting other errors..

    But hey ho sorted now

    cheers for the time

+ 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