Using listobject name reference in chart series issues after update

[s_szczesny]

Hello! I've encountered very weird behavior of Excel after latest update (semi-annual channel). Everything was working perfectly for over a year now.

I've created addin (VBA), that creates charts automatically from pulled SQL data. I used following format for series data definition:

SERIES NAME: =TABLE_NAME[[#Headers],[ColumnName]]
XValues: =TABLE_NAME[FirstColumnName]
YValues: =TABLE_NAME[ColumnName]

Data is stored in listobject (table with headers.)

A lot of other procedures are based on a fact, that i can pull TABLE_NAME, FirstColumnName, ColumnName directly from chart series object in VBA. But after the update Excel was automatically translating named references into cell addresses.

After hour of debugging I've found out, that if I plot 10 out of 11 columns, everything work just fine and the named references are untouched. But if I plot 11 columns out of 11, Excel is automatically translating all named references into cell ranges and i did not find any way to stop it.

Did anyone occur same issues?

 

[pbornemeier]

I have not seen that, but as a workaround could your modify your addin to add another column to the data then plot all but the last one?

 

[s_szczesny]

That is exactly what i did almost month ago. Still, adding virtual data to big data sets increase their size (sometimes substantially). Still waiting for proper solution - maybe MS engineer will fix it as i reported it as a bug.