Liz has attended:
SharePoint course
Embedded objects
I am inserting Word objects to create headers in Excel spreadsheets. The Word objects included tables. Its important for the row height and font to remain stable. I am struggling with this. If I crop the embedded Word object it seems ok until I save the Excel document. Then the Word object lengthens to fit its previous height and stretches font and rows accordingly. Why does saving make it uncrop?
Also, the objects seem to arrive with a default border. I have been changing to no line, no colour but would rather not have to do this every time. How do I set default please?
RE: embedded objects
Hi Liz
Please can you send an example? It would be good to see exactly how the formatting changes after saving.
Send to info@stl-training.co.uk and ask to be forwarded to me.
The the border outline looks like it has to be removed after inserting.
Sorry I can't be of more help at the moment.
Regards
Doug Dunn
Best STL
RE: embedded objects
Thanks for sending your file.
Once the embedded table is the size and format you want there is a way to keep the format from changing.
Right click, select Document Object, Convert
Then select Microsoft Word Picture.
This should work as long as you don't need to make further edits to the embedded table.
About the cropping, are you double clicking on the object then making changes?
Doug
Best STL
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
RE: embedded objects
Hello
Thanks for this, sorry its taken me so long to get a chance to look at your suggestion.
However, we do definitely need to make further edits to the embedded tables. So we need further advice.
I will contact Simon Mears because we have other issues with other templates and could perhaps need a focus session.
Kind regards
Liz
RE: embedded objects
Hi Liz
Sorry my sugestion didn't really apply. Yes, contacting Simon would be good to address this and support you with template issues.
Regards
Doug
Best STL
