MATHEMATICA LINK FOR EXCEL
-----
 /
Mathematica Link for Excel
*Features
*What's New in Version 3
*Who's It For?
*Examples
bulletUser's Manual and Reference Guide ManualPDF
*Buy Online

What's New in Mathematica Link for Excel 3

New in Version 3.7.3
  • Compatibility with Mathematica 12.3, 64-bit installers
New in Version 3.7.2
  • Compatibility with Mathematica 12.1
New in Version 3.7.1
  • Compatablility with Mathematica 12
New in Version 3.7
  • Compatibility with Excel 2016 (including Excel 2010 64-bit version)
  • Improved in Version 3.7
  • Updated Excel UI to support Office Fluent UI
  • Improved contextual menu support in Excel 2007 and newer to include a submenu for MathematicaLink in Excel (substituting Shift + right-click to display the Mathematica Context menu in Excel 2007 or newer)
  • Other minor improvements and fixes

New in Version 3.6.1
  • Compatibility with Mathematica 11

New in Version 3.6
  • Compatibility with Mathematica 9 and 10

New in Version 3.5
  • Compatibility with Mathematica 8.0
  • Compatibility with Excel 2010 (including Excel 2010 64-bit version)
  • ExcelShare function allows sharing a kernel between Excel and Mathematica
  • VBA support routines: MathematicaSet, MathematicaRun and MathematicaGet
  • Support for reading and writing Excel comments (including writing to a range using CellLabel["my comment"])
  • Shift-click the Mathematica "Evaluate" button to close link and bring up the Mathematica connection window
  • Shift + right-click a range to quickly display the Mathematica Context menu without turning on Mathematica Contexts

Improved in Version 3.5
  • Updated toolbar and menu icons
  • Improved Mathematica connection management (self-healing link and new connection options window)
  • Improved handling of Mathematica connection exceptions and evaluation interrupts
  • Improved Mathematica messaging (messages now returned in real time)
  • Improved "Display Message Box" option now only applies to Print[] output
  • Improved workbook initialization code evaluation and management
  • Improved common multi-workbook initialization now supported using an init.m file in same directory
  • Improved support for long-running Mathematica macros
  • Improved automatic workbook relinking and add-in startup logic
  • Other minor improvements and fixes

New in Version 3.2
  • Compatibility with Mathematica 7, including Mathematica 7-based icons
  • ExcelOpen, ExcelSave and ExcelDialog support for Excel 2007 .xlxs, .xlsm and .xlsb files
  • ExcelWrite support for writing Grid[{{1,2,3},{4,5},{6}}, opts] f.ex. ANOVATable output
  • ExcelFormat ["A:C", "AutoFit"] to automatically adjust column width
  • Support for 64-bit Windows and 64-bit Mathematica connecting to 32-bit Excel

Improved in Version 3.2
  • Improved message print format in Mathematica 6 and 7
  • Fixed bug where some workbooks with macro buttons do not relink correctly
  • Improved ExcelInstall[Visible -> True] method for launching visible instance of Excel
  • Improved Mathematica Macros inserting of code boxes and buttons
  • No "kernel connection closed" dialog if initialization code ends with Quit[]
  • Other minor improvements and fixes

New in Version 3.1
  • Compatibility with Mathematica 6
  • Compatibility with Excel 2007
  • Compatibility with Windows Vista
  • Keyboard shortcuts for Excel toolbar commands
  • Additional Excel message-related options
  • Restored backward compatibility with Excel 2000

Improved in Version 3.1
  • Improved editing of existing functions using the Mathematica function wizard
  • Improved compatibility with workbooks originally built with Version 2.x of Mathematica Link for Excel
  • Improved printable PDF documentation

New in Version 3
  • Display of typesetting and formatted output in Excel
  • Ability to create Mathematica-based macros
  • Suite of Mathematica functions to interact with and automate Excel

Improved in Version 3
  • Improved set of worksheet functions allowing you to build and evaluate Mathematica expressions in Excel even more easily.
  • Increased worksheet function speed. Worksheet functions now calculate up to eight times faster.
  • Increased worksheet function reliability. Worksheet functions are now robust enough for the most demanding spreadsheet applications. Automated tests have performed billions of continuous evaluations without errors.
  • Improved worksheet function error handling. Dependent evaluations are now suppressed through the use of native Excel error codes.
  • Improved Mathematica message handling. Messages are now displayed and stored in a non-modal window. You can leave this window open, scroll through multiple messages, find the source of a message and even save messages to a log file.
  • Easier linking. If a Mathematica kernel is available on your machine it is automatically located. The Start/End Link button is now a more powerful Evaluate button that can be used to reevaluate a workbook, interrupt current evaluations or, by holding Shift, end a link without displaying a confirmation dialog.
  • Enhanced Mathematica function wizard allows you to browse for functions by category, explore options and edit existing formulas.
  • Standard packages are now automatically declared, by default, and can be browsed directly within the function wizard. This functionality replaces the Libraries dialog.
  • Improved copying and pasting is faster and more robust. View and modify your copied data directly in the new Mathematica clipboard window, which replaces the Kernel dialog. You can also type Mathematica expressions directly into the clipboard, evaluate them and paste them wherever needed.
  • Improved sharing of workbooks with others—just click Unlink in the Mathematica Options -> Workbook tab. If colleagues have Mathematica Link for Excel, they will be automatically prompted to relink formulas when they open your workbook.