Skip to main content
BustedKnuckles
Level 2
Oct 16, 2015 2:26 AM UTC
Solved

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

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.
JillsMatthewAccepted solution
Level 4
Oct 16, 2015 2:26 AM UTC

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

BustedKnuckles
Level 2
Oct 16, 2015 2:26 AM UTC

Thanks JillsMatthew. That worked!

Translate
JillsMatthewAccepted solution
Level 4
Oct 16, 2015 2:26 AM UTC

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

Translate
khurshid
Adobe Employee
Adobe Employee
Oct 16, 2015 2:26 AM UTC

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

Translate