Report Builder: How do I delete old dynamic control now referred to as "#REF"? | Community
Skip to main content
BustedKnuckles
BustedKnuckles
Level 2
October 16, 2015
Solved

Report Builder: How do I delete old dynamic control now referred to as "#REF"?

  • October 16, 2015
  • 3 replies
  • 1602 views

I created a Segment control using Report Builder's Request Wizard. The Wizard referred to it by cell address, like "SheetA1".  I then cut the control from the Excel file. There was no option to delete it. The Wizard then referred to the Segment control within the Segment selection as #REF and I can find no way to delete the obsolete choice from the drop down. So what is the proper way to delete obsolete segment control references? Thanks, BK

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by JillsMatthew

    After deleting the control, did you try closing and reopening the excel file? For me when I reopened the file, there was no #REF

    3 replies

    khurshid
    Adobe Employee
    khurshidAdobe Employee
    Adobe Employee
    October 16, 2015

    Hi,

    #REF appears in the drop down even when I delete it using DELETE button. I would advise you to contact ClientCare to get this submitted to Engineering team or you may go to ideas.omniture.com to submit this as an enhancement. Let me know if you have any further queries.

     

    Regards

    Khurshid Alam

    J
    JillsMatthewAccepted solution
    Level 4
    October 16, 2015

    After deleting the control, did you try closing and reopening the excel file? For me when I reopened the file, there was no #REF

    BustedKnuckles
    BustedKnucklesAuthor
    Level 2
    October 16, 2015

    Thanks JillsMatthew. That worked!

      Terms & ConditionsAccessibility statement

      Loading footer...