adds ticks around multi-word titles in chart references
Created originally on Bitbucket by aceMueller
attached change set built on 424 from fork on same; test case included; if a sheet has a multiple word title (sheet name), and a chart is embedded on that sheet, Excel opens it just fine (Excel 2007 on XP), but if you then change the data values in the columns, the changes ARE NOT REFLECTED IN THE CHART. But if the title is in ticks in the reference, then the changes are reflected. (And in fact, if one does this manually in Excel, one notices that the references in the chart data definition have ticks around the sheet names.) While I suspect that any title could be encased in ticks, but I don't know that, so this fix was the minimally invasive fix to a demonstrable problem.
Attachments: ticksAroundMultiWordTitles