If you find the material here useful, why not help to support it by buying my Google Apps Script and VBA Titles published by O'Reilly media Book Going Gas Videos Google Apps Script for Developers Google Apps Script for Beginners.Now it may be that you want to give two columns the same name (let's say this represented some kind of transformation where the labels before and after were the same), so it means that I needed to allow for an ID (to represent the source and target) and a label in the data As in other projects on this site, the java Script, css and html that does all this is stored as a series of parameter values in a parameter sheet- in this case the sankey Parameters sheet.

importing updating between access and excel-66

You should set this to a directory you have permission to create files in.

This is a single file with no dependencies (except to the d3library) and you can put it on a web site or mail it to someone as you wish.

After you share a workbook, many of Excel’s features can’t be used.

There’s a list of unavailable features for Excel 2003 on the Microsoft site, and in Excel’s help.

This looks like this Most of this you wont need to touch, but you can tweak the style (these are css style definitions) and header parameters to affect the layout and content of the final web page.

It is also possible to change the operation of the chart if you are comfortable with d3- you can find this in the chart Code parameter.Occasionally a client asks me to create a shared workbook in Excel, so two or more employees can work in it at the same time.It sounds good in theory, but I always try to come up with a different solution.(For Office 2007, you also need to install this hotfix (KB976477) and make the registry edits detailed in KB976811.Note, however, that on a 64 bit version of Windows, the new registry entry should go under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office.0\Common\General\) We are working on making this easier! Exception from HRESULT: 0x800401A8 If you get an error “Solver Studio Error: Unable to run model.Like many modern applications, Solver Studio uses . This Microsoft article has an overview, or you can view the technical details (but also see this very detailed article on changes made in . We have never noticed this as an issue, and indeed we find that Solver Studio starts up faster than many other Excel add-ins, adding no appreciable delay to Excel’s launch time.