I have tried a little doing something like this on the Mac but it doesn't work for me. However in the last post TIG, it seems that the update would not be automatic anyway. Do I understand that correctly? In that case a method that I have used is print or save the excel file to a pdf file that has been inserted in LO. update the pdf by over-writing to the same file and LO will update. But as I understand it the holy grail is to have auto update from SU to Excel to LO. You can probably script some of the process.
Now I wonder if anyone knows why inserted graphics are not at proper size, or is there some rule they follow?