+ Reply to Thread
Results 1 to 4 of 4

Should "Trace Precedents" disappear after hitting save?

  1. #1
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Should "Trace Precedents" disappear after hitting save?

    Hi,
    In Excel 2013, Should the "Trace Precedents" and "Trace Dependents" disappear after hitting save?
    Should these helpful blue arrows disappear when you save the workbook?
    Thanks
    Please * if you like the answer

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Should "Trace Precedents" disappear after hitting save?

    It's the same in 2010 and appears to be by design. You can get round it with a macro - see here: http://answers.microsoft.com/en-us/o...9ebaff0?auth=1
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Contributor
    Join Date
    12-30-2012
    Location
    Israel
    MS-Off Ver
    2007, 2016
    Posts
    642

    Re: Should "Trace Precedents" disappear after hitting save?

    Thanks a lot. Good to know! (although this time I won't be able to send the file as XLSM). I wonder why.. such arrows can be so helpful. Weird.

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Should "Trace Precedents" disappear after hitting save?

    You're welcome - and thanks for the rep.

+ 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. [SOLVED] Clear userform after hitting "Submit"
    By KLG519 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2015, 06:33 PM
  2. Excel Userform - can't step into VBA code. Hitting "F8" just pops up the form
    By RAMguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2013, 10:51 AM
  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. Resize "go to" window, that pops up for trace precedents and dependents
    By Ym77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2013, 12:05 PM
  5. Replies: 4
    Last Post: 06-15-2012, 03:00 AM
  6. Replies: 0
    Last Post: 05-31-2012, 09:58 AM
  7. [SOLVED] Hitting "tab" moves my cursor over one entire screen.
    By Eunice in forum Excel General
    Replies: 1
    Last Post: 04-25-2005, 01: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