+ Reply to Thread
Results 1 to 4 of 4

Trace Precedents not working

  1. 10-18-2022, 05:27 AM #1
    TheDebtCollector
    TheDebtCollector is offline
    Registered User
    Join Date
    10-18-2022
    Location
    london, england
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2208 Build 16.0.15601.20204) 64-bit
    Posts
    2

    Trace Precedents not working

    Hi Excel wizards,

    I'm having a rather confusing problem that I've been try to solve for a few days now. There is a few formulae, an example of one of which is ='Conversion Ratesvvv'!BY11. However, I don't know where/what 'Conversion Ratesvvv' is? When I click trace precedents, it gives me a black arrow. However, when I click on the arrow, it tells me this is from a location with the same name as my current workbook (even if I save under different names, this always changes to the workbook I am currently using). Hopefully the attachments below work (this is my first post!) and you can see the problem for yourself! I have cut off the name of the sheet, but it is the same as the one I am in.

    I have tried searching for Conversion Ratevvv in formula, but i can only find other cells that use it.


    Screenshot 2022-10-18 102149.pngScreenshot 2022-10-18 102234.png

    Many thanks in advance!
    Reply With QuoteRegister To Reply
  2. 10-18-2022, 05:39 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,428

    Re: Trace Precedents not working

    'Conversion Ratesvvv' is a worksheet name. If you display the tabs, you should be able to see it.

    ='Conversion Ratesvvv'!BY11 is cell B11 on worksheet 'Conversion Ratesvvv'. The equals sign ( = ) means it is a formula; in this case a simple link to a cell. The exclamation mark ( ! ) is just the separator between the sheet name and the cell address.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 10-18-2022, 06:25 AM #3
    TheDebtCollector
    TheDebtCollector is offline
    Registered User
    Join Date
    10-18-2022
    Location
    london, england
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2208 Build 16.0.15601.20204) 64-bit
    Posts
    2

    Re: Trace Precedents not working

    Thanks for your speedy reply! I'd love to visit manchester sometime also

    Just noticed the sheet is hidden! You are a legend
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  4. 10-18-2022, 11:54 AM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,428

    Re: Trace Precedents not working

    You're welcome. Thanks for the rep.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. trace precedents for all cells
    By ammartino44 in forum Excel General
    Replies: 2
    Last Post: 02-04-2015, 03:32 PM
  2. Trace Precedents not consistent
    By rockell333 in forum Excel General
    Replies: 5
    Last Post: 01-08-2015, 06:19 PM
  3. [SOLVED] Protect sheet but allow trace precedents / trace dependents?
    By abchak1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2013, 10:32 AM
  4. Trace Precedents
    By weinanpj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2010, 04:20 PM
  5. Keep Trace Precedents
    By koticphreak in forum Excel General
    Replies: 2
    Last Post: 03-16-2009, 07:29 PM
  6. [SOLVED] trace all precedents or dependents
    By Dave F in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-10-2006, 11:00 PM
  7. Trace Dependents and Precedents not working
    By Manish in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-11-2005, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1