Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SauveC
 
Posts: n/a
Default Adding Smart Tags to an unrecognized cell reference

When Smart Tags are turned on, Excel recognizes specific entries and will add
a smart tag where applicable. For example, if you enter MSFT, Excel will
recognize this as a stock symbol and add the smart tag. My question is how
do I get Excel to recognize an entry as a stock symbol and add the smart tag
if it doesn't do it automatically?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

I've never used smart tags, but I typed "smart tags" into the "ask a question"
box.

Part of the help screen (xl2002) showed this:

How to get more smart tags

You can click More Smart Tags (on the Tools menu, click AutoCorrect Options, and
then click the Smart Tags tab) to go to Web sites to find new smart tags and
actions.

Ah, you can read the rest in Help.

I clicked on a couple of links and found this:
http://office.microsoft.com/en-us/as...833041033.aspx
with this as a label to a link:
Creating smart tags and setting smart tag properties

I clicked on it and it didn't work for me. Maybe you'll have better luck.




SauveC wrote:

When Smart Tags are turned on, Excel recognizes specific entries and will add
a smart tag where applicable. For example, if you enter MSFT, Excel will
recognize this as a stock symbol and add the smart tag. My question is how
do I get Excel to recognize an entry as a stock symbol and add the smart tag
if it doesn't do it automatically?


--

Dave Peterson
  #3   Report Post  
SauveC
 
Posts: n/a
Default

Dave, thanks for trying. I had already been there and all it did was provide
me with more "types" of Smart Tags. I was not able to figure out how to make
Excel recognize a cell entry as a stock symbol if it didn't attach the Smart
Tag automatically. If you have Smart Tags turned on and you enter MSFT in a
cell, it will automatically attach the Smart Tag, but when I try to enter the
stock symbol for my company it doesn't.

"SauveC" wrote:

When Smart Tags are turned on, Excel recognizes specific entries and will add
a smart tag where applicable. For example, if you enter MSFT, Excel will
recognize this as a stock symbol and add the smart tag. My question is how
do I get Excel to recognize an entry as a stock symbol and add the smart tag
if it doesn't do it automatically?

  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

Could you get that link that had the label of:
Creating smart tags and setting smart tag properties
to work for you?

Maybe there's something in there that will help.

SauveC wrote:

Dave, thanks for trying. I had already been there and all it did was provide
me with more "types" of Smart Tags. I was not able to figure out how to make
Excel recognize a cell entry as a stock symbol if it didn't attach the Smart
Tag automatically. If you have Smart Tags turned on and you enter MSFT in a
cell, it will automatically attach the Smart Tag, but when I try to enter the
stock symbol for my company it doesn't.

"SauveC" wrote:

When Smart Tags are turned on, Excel recognizes specific entries and will add
a smart tag where applicable. For example, if you enter MSFT, Excel will
recognize this as a stock symbol and add the smart tag. My question is how
do I get Excel to recognize an entry as a stock symbol and add the smart tag
if it doesn't do it automatically?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
Cell Reference Math Ralph Howarth Excel Worksheet Functions 0 January 26th 05 06:27 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
name of another worksheet in cell for reference Tom A Johnson Excel Worksheet Functions 2 November 11th 04 11:28 PM
cell reference show cell name (ie. D45) and not cell value ria Excel Worksheet Functions 4 November 6th 04 04:38 AM


All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"