Dynamic Camera Object - Resizing With Dynamic Array

[shellp]

Hello,

I have a dynamic array where the number of rows changes based on the selection of the user. I found another post (sorry, not sure where or if it was this one) advising to use an offset formula for the object and use that as data source. I did this and it works while the document is open but when I save it and come back to it the next morning, the image size stays the same and the object displays as cramped/distorted.

I have a field in the "source" worksheet identifying the number of rows + 1 and it is:

Offset(data_page!$S$5,,,data_page!$AE$1,16)

AE1 is where the rows+1 is, the image starts at S5 and I want the 16 columns across. Is there something wrong with my formula? How can I get the object to resize according to the data and be legible?

Any and all assistance greatly appreciated.

 

[RoryA]

A gentle reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Camera Object With Dynamic Array

Forum

www.myonlinetraininghub.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[shellp]

Thanks Rory. I apologize as this is my second infraction. The project I'm working on is driving me so crazy that I didn't realize I posted here as well as My Online Training Hub.

In addition, the research so far indicates that my issue appears to be a bug with the camera tool in 365 but would love if someone could help with a solution. Thanks.