Excel's new IMAGE function is simply amazing. Check out this HR Dashboard that allows you to lookup images stored in your Google Drive as you select different staff names in #Microsoft #Excel.
Пікірлер: 19
@claireelwick86347 ай бұрын
Amazing, that has shown me exactly what I needed, thank you!
@PhallyPangASRHR Жыл бұрын
Great tips ever, Thank you
@alfulaij Жыл бұрын
Very nice video explanation
@prayagsingh52679 ай бұрын
Excellent Explanation
@shadrackawunyo77862 жыл бұрын
Great trick...
@alfulaij Жыл бұрын
I tried to use your guide and I got all my images into the excel file, but I have a new problem. I am pulling from hi-res product images, and the excel file has become too large >200MB, I thought the image functions simply points to the stored online image and not actually import it and saves it in the excel itself! is there a way around this?
@FinexSkillsHub Жыл бұрын
I did a little reading here on this support.microsoft.com/en-au/office/how-to-correct-a-blocked-error-13be117b-92e4-400a-a215-aa59d37d6e7c and it appears file size could be an issue.
@Veryverybry Жыл бұрын
Hello, is this possible for images saved in dropbox?
@FinexSkillsHub Жыл бұрын
We have not tried on Dropbox yet.
@user-te6vr8lh7x10 ай бұрын
can i do this with onedrive images? and what is the default link
@diegocg394 Жыл бұрын
Excellent video, one question how can ı get the "default link"?
@FinexSkillsHub Жыл бұрын
Link here: drive.google.com/uc?export=view&id=
@marianamofa6201 Жыл бұрын
The link is returning as Error 400 @@FinexSkillsHub
@TechVerseAi10 ай бұрын
my EXCEL IS NOT SUPPOTING "TEXTAFTER' & "TEXTBEFORE" FORMULA, WHAT CAN I DO?
@FinexSkillsHub10 ай бұрын
You can use LEFT, MID or RIGHT functions to extract the text.
@giddajallow3064 Жыл бұрын
I tried it but the outcome is indicating #BLOCKED!
@FinexSkillsHub Жыл бұрын
It's a security setting. So enable content in the yellow bar on top of your worksheet or make the file a trusted document. Select File > Options > Trust Center > Trust Center Settings.
@giddajallow3064 Жыл бұрын
@@FinexSkillsHub Thanks. The default link too is constant right?