Home

Formula access to Shape Data from Text Callouts

%3CLINGO-SUB%20id%3D%22lingo-sub-1216720%22%20slang%3D%22en-US%22%3EFormula%20access%20to%20Shape%20Data%20from%20Text%20Callouts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1216720%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20access%20from%20a%20text%20callout%20my%20Shape%20Data%20that%20contains%20my%20connected%2Fimported%20Excel%20column%20data.%20I%20am%20currently%20hard-coding%20it%20Shape%20by%20Shape%20by%20their%20Sheet%20numbers%20(i.e.%20Sheet.81!Prop._VisDM_MyExcelDataFields).%20This%20works%20but%20each%20Shape%20has%20different%20Sheet%20numbers.%20Is%20there%20a%20way%20in%20a%20formula%20in%20my%20Text%20Callout%20Shape%20Data%20and%20Hyperlinks%20that%20I%20can%20access%20the%20imported%20Sheet%20data%20more%20generically%3F%20I%20tried%20Sheetref()!Prop._VisDM*%20in%20a%20Hyperlinks%20section%20but%20that%20didn't%20appear%20to%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1216720%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EVisio%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

I am trying to access from a text callout my Shape Data that contains my connected/imported Excel column data. I am currently hard-coding it Shape by Shape by their Sheet numbers (i.e. Sheet.81!Prop._VisDM_MyExcelDataFields). This works but each Shape has different Sheet numbers. Is there a way in a formula in my Text Callout Shape Data and Hyperlinks that I can access the imported Sheet data more generically? I tried Sheetref()!Prop._VisDM* in a Hyperlinks section but that didn't appear to work.