I just installed Excel2LaTeX in Excel 2010.
I do see it in add-ins. However, I cannot find a way to operate it. That is, there is no change in the ribbon area after the package was installed.
How does one use the package?
Asked
Active
Viewed 7.1k times
29
-
Welcome to TeX.sx! You don't have to sign with your name since it automatically appears in the lower right corner of your post. – Andrey Vihrov Aug 04 '11 at 15:35
-
1This is really off-topic here, since your problem is with Excel and an add-in, and not with TeX itself. – Alan Munn Aug 04 '11 at 15:36
-
7@Alan: Conversion tools are usually on-topic. – Caramdir Aug 04 '11 at 16:06
-
2I second Caramdir: "If you have a question about [...] (La)TeX related software and tools like BibTeX, LyX, LaTeX editors, viewers, and converters ... then you're in the right place to ask your question!" (FAQ) – doncherry Aug 04 '11 at 17:27
-
It does NOT work in Excel 2011 for Mac. For 2010 and 2007 I had to restart to see the ribbon. Microsoft is hopeless. – Aram Kocharyan Oct 04 '11 at 02:11
4 Answers
29
After an add-in has been installed, it is available to use, but it has to be activated first. For this, follow these instructions. An abbreviated list of steps are:
- Click the Microsoft Office Button.
- Click Excel Options.
- Click Add-Ins.
- Note the Add-in Type in the list displayed.
- Select the Add-in Type in the manage box and click Go.
- Select [clear] the check box for the Add-in that you want enable [disable] and then click OK.
Specifically for the Excel2LaTeX add-in for Excel, after downloading it and reaching step 5 above, this is how I installed it on my computer:
- Locating the Excel2LaTeX add-in by clicking on the Browse button:
- Activating the Excel2LaTeX add-in by selecting it from the add-in menu:
- New add-in menu showing the "Convert to LaTeX table" button in Excel:
Note that any add-in is specific to the location that it is stored in, since the code/macros are stored in a file rather than being "installed" under your traditional "Program Files" folder. So, it would be preferable to put it in a recognizable folder that you can find and access later. That is, avoid putting it in something like C:\Temp\ where it may be easily erased.
Werner
- 603,163
-
1I did activate it. However, there is no new buttom that allows me to copy a table into LaTex. – Slava Aug 04 '11 at 16:58
-
1@Slava: I've updated my answer to show what I did to get it installed on my computer. I did this in Excel 2007. However, the CTAN link I provided suggests v3.1 (as of May 19, 2011) of the Add-in works for Excel 2007+. Perhaps you have an older version that may not be compatible. – Werner Aug 04 '11 at 18:19
-
1after restarting excel, the button should be there. Thankts for the instructions, for me it works! – Oct 19 '11 at 12:38
-
Will the add-on also extract the graphs from the excel file or only data? – Jeel Shah Mar 12 '13 at 00:33
10
Use this online version instead! No installation necessary.
frickskit
- 321
- 3
- 8
-
-
1That tool is pretty buggy, and doesn't convert things like merged cells. – Adam_G Mar 13 '15 at 12:13
0
I'm using Excel 2013 and did initially not manage to get Excel2LaTeX to show in add-ins, it seems to work for some people and not for others using the same version of Excel. What worked for me was to disable all other add-ins that were listed before Excel2LaTeX . When I did that Excel2LaTeX showed upp in add-ins and works! 
Wille
- 1
0
Although, the question is for Excel 2010, I think Excel 2020 is also relevant here.
I have to do 2 extra steps to make it working in excel 2020.
- Unblock the xla file by going to properties and check the unblock as highlighted in the picture.
- After unblocking open the file and try to run excel2latex functions by going to Add in tab. A pop up will appear asking to allow macros. Allow them and everything will work.
DivineCoder
- 101