The only issue I've ever had with using embedded cells is the Page x of y ability. Can't do that within the spreadsheet without macros. So I usually keep that in the footer since it's not "critical or confidential information"
In one place I worked, I used imbedded Word Docs since their header formatting couldn't be reproduced by Excel. That's a pain though.