Jan 15 2019 02:16 PM
So I have some fancy chart that covers a dynamic range using named ranges + offset() functions. Certainly these are some of the things that strain the limits of excel without entering the abyss that is VBA customization, so I expect some degree of fuss, but everything has been working well in recent history.
THis new chart is in an excel document that sees heavy co-authoring, and is stored in SharePoint. After I close the sheet and re-open, all of the ranges I specified in the chart data get converted to references to "_r{1}", "_r{2}", ... "_r{9}" etc. Which I assume are references to some static dataset.
Is this a product of co authoring? Has anyone seen this, and more importantly has anyone an idea on how to work around it?
Jan 17 2019 02:27 AM