I decided to do another short post to save you some time. This image/post takes a look at how to setup the camera tool and then how you can use it on a separate worksheet to begin the setup of a new dashboard. The Excel Camera Tool allows you to take an image of a range of cells and create a picture/object out of it. Once that picture is created, it will automatically continue to refer to the cells that the image was taken of and will update as the cells change. Feel free to leave any questions in the comments.
thats it Great it help for report design, can I’have copy ?
Best regard
Earlier this year I set this up to keep an eye on some monthly reports that my dashboards were dependent upon. I figured linking the snapshot to my desktop would be a quick way to check if the monthly data needed for the dashboards had been reported.
I found that one of the snapshots always worked, while one never updated. Same server, same network, etc. So I stopped using the snapshot tool in that manner.
Hi Renee,
That’s really disappointing. I’m glad you’ve brought this up. I would imagine if you’ve experienced these types of issues that others have as well. I’ll have to see what I can find out there for possible reasons on why this would potentially happen. If I do find anything I’ll be sure to update the article.
Thanks for the update Rennee.