Hello,
I have a dynamic (spill) array that is working. I want to use the camera tool to use this data in a dashboard. I thought that maybe setting the formula to an offset() in a named range and enter that as the source data for the object would suffice, and it did when I first did so, but once saved and back to it the next morning, the camera image distorts with the change of the number of rows in the table.
Is there any way to fix this? Thanks.
I didn't see any way to edit my post, but I am looking for having a camera object correctly work with a dynamic array that grows/shrinks depending on what the user selects. However that is possible to happen, whether related to how I've already tried, doesn't matter. Any and all assistance greatly appreciated.
Cross-posted: https://www.mrexcel.com/board/threads/dynamic-camera-object-resizing-with-dynamic-array.1271268/
Just to close the loop: I found documentation indicating that the camera tool in 365 doesn't work the same way as previous versions with regards to the source being a dynamic array. Previously, I would have created a named range using offset() for the data used in the camera and then used the named range as the camera object data source. As a workaround, I wrote code to copy the new data range, and paste as object. Thanks.
