Forum Discussion
Images in Headers not working and causing issues printing
Matt_MobiusNZ Indeed frustrating when things don't function as you expect them to. But, allow me to add one more comment. In your screenshot you show the Insert ribbon while inside the header. Don't you have a separate "Header & Footer" ribbon when you click inside the header? See picture below. I have all the header and footer options here, including inserting pictures and reformatting them once inserted.
This is my Excel version, running W10 on a virtual machine on a MB Pro.
I recently posted a tutorial focusing on Headers & Footers including (among other topics) the issue of adding a logo and resizing it. It also shows how to customize the header once for many Sheets simultaneously and how to link a header to cell value in the worksheet.
You can watch the tutorial by clicking on the link:
https://www.youtube.com/watch?v=h27gGZD9JBk&t=56s
Hope that helps
Nabil Mourad
Yip - Know HOW to do it - Its the fact that it has STOPPED working. The way you demonstrate Riny still works to add it but Excel crashes when you try and print. Not always but often including with images and headers that printed perfectly up until very recently. Its also a dreadful interface as you can't position the image in any real way, you can't resize it or anything unlike inserting an image anywhere else.
Turns out when the client finally got back to me with more information these are spreadsheets that have worked for years have suddenly started crashing when printing with a Picture in the header. Now I just have to work out if its an Excel bug in a recent release (We are both fully up to date on Subscription Business 365 plans) or if its a strange issue linked to the recent printing bugs Microsoft have introduced in Windows 10.
Neither of us have the symptoms introduced with recent 10 updates that make print spooler crash when printing but it could but the fix for that bug has caused another but I suspect its an Excel update issue as previously you could go into layout mode and insert pictures into the header directly and now you can't - In the insert Tab the only option available is the Illustrations drop down (Where all images, clipart etc is grouped now) but all options in the drop down are greyed out too.
Matt_MobiusNZ Indeed frustrating when things don't function as you expect them to. But, allow me to add one more comment. In your screenshot you show the Insert ribbon while inside the header. Don't you have a separate "Header & Footer" ribbon when you click inside the header? See picture below. I have all the header and footer options here, including inserting pictures and reformatting them once inserted.
This is my Excel version, running W10 on a virtual machine on a MB Pro.
Thanks Riny - Thats good info - I'd completely missed that and the answer is Sort of 🙂
Looks like microsoft Rapid development is at it again. You are dead right, by default when in Layout view and sitting in the Header it takes me to a new ribbon - Although mine is called "Design" not "Header and Footer" like yours but the content looks the same so Microsoft must be dabbling and finalising what they are doing. That ribbon does make it much easier to add the pictures and does work but its still a terrible far from WYSIWYG as you can't resize the image once its inserted. Interestingly even when I insert a massively oversized image that ends up being a background for the entire sheet rather than sitting in the header the file will print for me.
Now I need to work out if something has become corrupted in his sheet or if Microsoft have pushed some rapid development fixes out overnight because yesterday Mine wouldn't print with a Brand new sheet with an image inserted in the header.
It was just tricky as every search I did lead to documents referring to the wrong instructions for older versions of Excel and I found one reference that seemed to indicate images weren't supported in Headers which seemed to fit with the inability to insert using the insert tab. No idea why MS Dev's decided that the logical way to insert a picture in a header isn't the right way.