I don't know how many people do this manually, but editing any header in a design table causes excel to think it's an email address, so it gets converted to a hyperlink.
Is there any way to stop this happening by default? It usually takes two selections to tidy up, one to remove the hyperlink, one more to reset the formatting. Unless you accidentally click the link, then you've got email or web browsers popping up too.
I think it's more of an excel issue. Just right click the hyperlink and select remove hyperlink. Hope it answers your question.
Oops, I didnt get the question right. My suggestion is just a quick remedy. I dont know how to remove it by default. But you can avoid having hyperlinks in your design table by renaming the dimension name in properties rather than inputting it in the Design Table.
Type and ' before one and use format painter to apply to all of them.
Say for example you have D1@Sketch1, so in excel cell it'll be 'D1@Sketch1
While in Excel, go to Tools > AutoCorrect Options > AutoFormat As You Type and deselect Internet and network paths with hyperlinks
For all of you who have to trouble finding stuff in Office 2007.
Thanks Kelvin, that's exactly what I was looking for.
Thanks Wayne, would have taken me a lot longer to find it without that pic.
While in Excel, go to Tools > AutoCorrect Options > AutoFormat As You Type and deselect Internet and network paths with hyperlinks