Smart Tags in Excel document

Page 1 of 1 (10 items)
This post has 9 Replies | 2 Followers

Posts 5
Jason Wilkerson | Forum Activity | Posted: Tue, Mar 8 2011 8:23 AM

I am new to this, and I have searched for a discussion that addresses my question and have not found it.  No doubt, someone will say, "We've discussed that before..." and if so, just kindly direct me accordingly;

I have a huge Excel file in which, for years, I have entered biblical references topically, as I have found them.  What I have are thousands of references in a spreadsheet.  This is much more effective for me than something like Nave's Topical Bible.  But, I'd love to find some way to have all those references "hot-keyed' to a pop-up window of the text.

Can this be done?  (Please be aware, I am NOT a computer programmer, and the word "code" for me is code-word for: you're in over your head)

 

Posts 3805
spitzerpl | Forum Activity | Replied: Tue, Mar 8 2011 8:37 AM

what version of excel are you using? 2003, 2007, or 2010?

Posts 5
Jason Wilkerson | Forum Activity | Replied: Tue, Mar 8 2011 8:42 AM

Excel 2007

Posts 3805
spitzerpl | Forum Activity | Replied: Tue, Mar 8 2011 4:25 PM

I know smart tags work in 2010, not sure about 2007 but I would think so.click on the button in the upper left corner, then Options>proofing>auto complete. Make sure their is a check next to  the Logos box. Once that is done you may need to close down excel and reopen it. I'm not sure how L4 indicates that a box is a smarttag. I think a little box appears when you hover over a cell with a verse in it (I'm assuming the verse isI the only thing in the cell.) You might have to right click to get an option for the smart tag.

 

Posts 5
Jason Wilkerson | Forum Activity | Replied: Tue, Mar 8 2011 6:35 PM

In Excel 2007, there is no auto-complete option under proofing.  Perhaps that is something only in 2010.  Also, I am using L3, not L4 (I know, I'm way behind the times).  Is this something I need to upgrade to L4 and Excel 2010 in order to use?

Posts 3805
spitzerpl | Forum Activity | Replied: Wed, Mar 9 2011 2:23 AM


Ah, L3 is different. http://www.logos.com/articleviewer/530seems to indicate that smart tags now require L4. Even if you go through their L3 support page the smart tag link sends you to the above link. I think that means that unless someone can send you the old smart tag installation file you might be out of luck without switching to L4.

The good news is smart tags not only work with 2007, but they work better then in 2010. At least, that's my opinion. So no, you do not need to upgrade to excel 2010. If you choose to take the L4 plunge we are here to help you with any questions you might have!

Posts 5
Jason Wilkerson | Forum Activity | Replied: Wed, Mar 9 2011 6:38 AM

Philip,

Super-helpful.  I see how smart tags must happen, now I just need to figure out if I can make them work with L3 without upgrading.  Again, thanks for pointing me in the right direction.

Posts 2
anoop | Forum Activity | Replied: Tue, Oct 16 2012 11:52 PM

I have a huge Excel file in which, for years, I have entered biblical references topically, as I have found them.  What I have are thousands of references in a spreadsheet.  This is much more effective for me than something like Nave's Topical Bible.  But, I'd love to find some way to have all those references "hot-keyed' to a pop-up window of the text.


message in a bottle

Posts 2
anoop | Forum Activity | Replied: Tue, Oct 16 2012 11:54 PM

I have a huge Excel file in which, for years, I have entered biblical references topically, as I have found them.  What I have are thousands of references in a spreadsheet.  This is much more effective for me than something like Nave's Topical Bible.  But, I'd love to find some way to have all those references "hot-keyed' to a pop-up window of the text.

plastic bottle

Posts 8441
Forum MVP
NB.Mick | Forum Activity | Replied: Wed, Oct 17 2012 2:36 AM

I think this is a link spam post with the text stolen from the OP and have reported this thread.

Running Logos 7 latest (beta) version

Page 1 of 1 (10 items) | RSS
Copyright 1992-2015 Faithlife / Logos Bible Software.