Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Hyperlinks - Excel using Spudoft emmiter is invalid reference
Migrateduser
<p>I am struggling with getting an internal hyperlink to work correctly.</p><p> </p><p>I have tried various ways.</p><p> </p><p>One just creating a href html tag.</p><p><a href="#sheet1!A!">sheet1</a></p><p> </p><p>This when rendered in excel gets changed</p><p>When mouse over the link I get sheet1_A1 not sheet!A1 as expected.</p><p> </p><p>The same thing happens when I have a bookmark</p><p>And I create a hyperlink in the properties.</p><p>I end up with the same issue.</p><p>When looking at in excel I endup with sheet1_A1 which is invalid reference.</p><p> </p><p> </p><p>I have tried escaping the ! no luck</p><p>Even played with some EventAdapters.</p><p> </p><p>But I am stuck.</p><p> </p><p>I can get the HYPERLINK("sheet1","sheet1") to work but it does not end up highlighted as a link.</p><p> </p><p>Anyone else had success?</p><p> </p><p>I can't figure out what I am doing wrong.</p><p>Obviously something.</p><p> </p><p>Gary</p><p> </p><p> </p>
Find more posts tagged with
Comments
There are no comments yet