Michail has attended:
Excel PowerPivot course
Dynamic Picture Linking in Excel and Pivot
How we can insert a picture in a cell in a dynamic way (be part of a specific cell), so if we filter for instance the contents, the picture will stay connected/linked to its original row and move with them
RE: Dynamic Picture Linking in Excel and Pivot
Hello Michail,
Thank you for your question regarding dynamic picture linking in Excel and Pivot.
It would be really helpful if you will expand your question and explain exactly where you wish to place the picture? How large will it be? Any other useful info will help.
Send a copy of the sheet you wish to do this in and I'll take a look at this.
Send to rl@stl-training.co.uk
Awaiting your reply.
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
RE: Dynamic Picture Linking in Excel and Pivot
Hi Rodney
Passport size picture
I don't understand your other question
I have rows of data with client details (name, address, etc) that will manipulate with pivot table. I want one of the columns to store that person's picture in a dynamic way so it can appear along with the other data
if for instance I make a query to bring me the info of all male clients aged 45-55, I will get:
Name Picture Tel Address. Etc
RE: Dynamic Picture Linking in Excel and Pivot
Hello Michail,
I have attached a file with some data pertaining to people including some pictures. You can sort and filter this data and the picture moves with the related cell. Check the picture properties to see the option chosen. Always make sure that the picture is placed inside the cell borders.
Pivot tables do not allow you to place pictures into cells. Even if you were to create a PivotTable of the data and add the image field to row or column labels area, the result will always be (Blank).
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Attached files...
FileWithPictures.xlsxRE: Dynamic Picture Linking in Excel and Pivot
Rodney, you are a star! how simple it is to tick the 'Move and size with cells' option for each picture.
What a shame that functionality cannot be used in Pivot/Power Pivot (that was the main reason that I've attended the course)
I could have saved 2 days of my time, since I didn't really learn anything new (besides the relationships, which I am not going to use since I don't have my data in Access or other external database).
Please take a moment to read my evaluation for the Power Pivot course, because it is important for BEST STL to make major drastic changes to its contents and duration.
Moreover, please be clear to people who know/have used Pivot Tables, that Power Pivot is just a more powerful add-in which does pretty much the same thing but has the capability to connect with external/large DBs.
We don't need to come to 2 day course to hear that. And what added more to my frustration was the fact that BEST STL hasn't figured out how to make the add-in work with Windows 7. After spending a few hrs myself on the subject, I finally figured out the way and shared it with the trainer, so you can update the manual.
Best Regards
Michail
RE: Dynamic Picture Linking in Excel and Pivot
Hello Michail,
Thanks for your comment.
I actually thought this post was complete, however, I would like to add that we have taken note of your comments regarding our PowerPivot course and will make a decision on the duration of future courses after we have run a few more. We will then analyse other delegates' comments and if necessary, adjust our schedule accordingly.
I would like to mention that I have two personal laptops one with Vista Home 32 bit and the newer one running Windows 7 Home Premium 64 bit. I added the PowerPivot add-in software to both computers and had no problems whatsoever with the installation. I know that Simon experienced some issues loading onto his own personal laptops and I think it has something to do with the version of Microsoft .Net framework on a computer.
Incidentally, we run a one day PivotTables course which I have personally conducted on many occasions and have found this to be an excellent course. Even delegates who have experience with PivotTables have found that they have benefitted from the course. It covers PowerPivot to a lesser degree than the 2 day course, so my guess is that you may have benefitted more from this course.
Please mark this question as resolved.
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
