locked
Word with embedded Excel Spreadsheet - Excel opens outside of Word RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Office 365 1803 (9126.2152)

    I have a Word 2016 document with an Excel Spreadsheet (table) inserted in the document. The table and text all fit on one page. At the end of last week, when I double-clicked on the embedded Excel, the Word interface changed in the Word window "into Excel" and I could edit the Excel table "within" the Word document and Word interface. This editing method had the advantage that I could easily change the size of the table "window" (drag the width and height of the table to show more or less columns and/or lines of the excel). Now, when I double-click on the table in any of the documents (invoices), Excel is started in a separate window. I can edit the table in the separate window and the changes are "saved" into the word document, but no matter what the "status" of the table, dragging the borders of the table in Word simply scales the window, I cannot see how I can fix the area of the table to be displayed in the word document (e.g. extend a "calculation" in the table and show an additional 3 lines to be displayed in the word document).

    As far as I am aware, I (or my admin) have done nothing to the configuration of Word or Excel in the meanwhile (oh, I did get an update 11.04, but I can no longer tell what is being applied to my machine by Microsoft, so I don't know if that caused this change).

    Any help in either:

    1. Defining how the area of cells to be displayed in the Word document can be changed without having to re-create the Excel
    2. Defining how to force excel to "open" within word

    would be deeply appreciated.

    John. 

    John Mantle, QuantityWare GmbH

    Saturday, April 14, 2018 12:48 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Just finishing this one up. It took until July, but since then I have no longer had this effect and embedded spreadsheets open as expected, "within" Word. 

    John Mantle, QuantityWare GmbH

    • Marked as answer by John Mantle Tuesday, November 20, 2018 10:08 AM
    Tuesday, November 20, 2018 10:08 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    Seems you're not alone. There's a parallel discussion at: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_win10-mso_365hp/embedded-excel-file-opens-in-a-separate-window-in/e1dd639e-6d3f-4fa4-82de-c07e8eb65839

    Cheers
    Paul Edstein
    [MS MVP - Word]


    Saturday, April 14, 2018 6:07 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for the fast response, but this has not helped me - however this is exactly the same symptom that was reported in the other thread.

    What would be good to understand is why this symptom occurs- as far as I was aware, I made no changes to my Office configuration. All I noticed was that after a reboot for updates, the behaviour of Word in this instance had changed.

    Maybe it was a bad move for MS to fire all the testers and try to substitute professionals with well-meaning amateurs ("insiders"); the product quality has taken a real nose-dive.

    If Microsoft would like me to provide any for of information, I will be willing to support.

    Thanks,

    John. 

    John Mantle, QuantityWare GmbH

    Saturday, April 14, 2018 2:33 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi John,

    I tried to test in my Word 2016 (Version 1803, Build 9126.2152) by inserting an Excel worksheet via Insert > Object > Excel Worksheet , but cannot reproduce the issue:

    Did I misunderstood anything? 

    Regards,

    Yuki Sun

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Monday, April 16, 2018 9:29 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Yuki,

    thanks for looking at this.

    I have the same release (click to run).

    Before a set of MS updates, I had exactly the same behaviour as your installation displays, which is what I want. After the updates, all existing embedded XLs in Word documents are opened with Excel in a separate window. I have also just checked and with your procedure above (Insert > Object > Excel Worksheet)  or as I see it "Einfügen -> Objekt -> Microsoft Excel Worksheet" (my installation is in German, but that's only a display language...) I get the spreadsheet also opening in a separate Excel window...

    I don't really want to have to de- & re-install Office.
    Any Ideas?
    Thanks,

    John.

    John Mantle, QuantityWare GmbH

    Monday, April 16, 2018 9:49 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi John,

    To help troubleshoot the problem, could you please try running Word in safe mode and check the result? To do this, please press Win+R, type "winword /safe", press Enter. 

    If the issue persists, please try to  perform a clean boot in Windows. This helps eliminate whether the issue was caused by any software conflicts:

    https://support.microsoft.com/en-us/kb/929135

    Any findings, please feel free to post back. 


    Regards,

    Yuki Sun

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Tuesday, April 17, 2018 3:14 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Yuki Sun,

    thanks for replying to me - I was on a business trip. I am now back and referred to the post referenced by Paul Edstine, previously.

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_win10-mso_365hp/embedded-excel-file-opens-in-a-separate-window-in/e1dd639e-6d3f-4fa4-82de-c07e8eb65839

    In that thread someone proposed that it was an error on double-monitor setup - well, I posted an "answer" that confirms this. It is a serious MS Bug that was introduced a couple of weeks ago with MS updates and I am very annoyed. If you can please pass this onto support I would be very happy if they fixed this bug as soon as possible!.

    Best regards,

    John.

    John Mantle, QuantityWare GmbH

    Friday, April 20, 2018 12:18 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi John,

    Thanks for sharing the valuable information here. I have tried to submit this via our limited internal way. In the mean time, it is also recommended that you send the feedback using the Feedback option in the user interface. 

    For now, if you are in a hurry to use the feature on double-monitor setup, personally I'd like to suggest trying to revert to an earlier version of Office to work around the issue.

    By the way, could you please help mark you post above as answer so that others who might encounter a similar question can more easily find the cause for the problem? Thanks for your understanding and support. 

    Regards,

    Yuki Sun

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Wednesday, April 25, 2018 6:53 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Yuki,

    I have reported it via feedback too - thanks for the prompt and the fact that you have patently tried to help me on this "voyage of discovery" ... ;) 

    I think that the revert is very cumbersome and to perform this for multiple domain computers will take a lot of time and effort. I just hope that MS takes its responsibility to its customers seriously and fixes this ASAP.

    John.

    John Mantle, QuantityWare GmbH

    Wednesday, April 25, 2018 11:07 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Just finishing this one up. It took until July, but since then I have no longer had this effect and embedded spreadsheets open as expected, "within" Word. 

    John Mantle, QuantityWare GmbH

    • Marked as answer by John Mantle Tuesday, November 20, 2018 10:08 AM
    Tuesday, November 20, 2018 10:08 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I don't see what you did.  I am currently experiencing the same problem.  If you see this and remember, would you mind posting the solution?  Thank you.
    Wednesday, March 13, 2019 3:31 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    As far as I was concerned it was a problem with dual monitors. Putting in a couple of updates released by MS at the time solved it for me. The dual monitor issue is easy to define - just shutdown the machine, remove the external monitor (notebook scenario) or all monitors but one (geek/gamer scenario) reboot the machine and test - with one monitor the problem did not ocurr.

    I must say that I also received the same error last week when opening a Word document with embedded XL on another machine, but swearing loudly, closing the document and re-opening it worked for me.

    Best regards.

    John Mantle, QuantityWare GmbH

    Wednesday, March 13, 2019 4:07 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thank you to all who contributed to this.  This has been bugging me for a long time.  Wish they would fix it. 

    My input:

    I can duplicate the problem on all machines in the office by going in and out of dual monitor mode.  On one desktop machine with dual monitors it continues to pop out as a separate spread sheet so is not consistent problem.

    I personally like the pop out spread sheet IF you could resize to the cells you want to display.  It is nice to have them side by side and you can edit in Word and Excel as you go.

    Tuesday, March 19, 2019 3:48 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    In short, you have to have the same "scale" on every monitor for embedded OLE to work (no idea why).

    Right click on you desktop, pick "Display Settings" then scroll down to "Scale and layout".  I have everything set to 100% which fixed it.

    • Proposed as answer by Mat Ludlam Thursday, February 13, 2020 2:04 PM
    Thursday, February 13, 2020 2:04 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Word 2019 running Windows 10 1909, both fully patched, running a monitor @ 175% and just added another monitor scaled at 100% and now the embedded Workbook opens up into an Excel document.  I set the 2nd monitor to 175% and tried again and it works perfectly.  Problem is monitor #1 is a 32" 4k @ #2 is a 24" @ 1K.  175% on a 24" 1920x1200 monitor is truly below average.  Any plans on fixing this Microsoft?  I see the posts go back to 2018.
    Wednesday, February 19, 2020 1:25 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I had a bad feeling when I read you post, btc909, as I was planning to edit such a document today... NOw it was workinng before the last MS Office update...

    C'mon, Microsoft this is just terrible.

    Microsoft Office team, have now broken and fixed this around 4 times over the past two years. You have broken it AGAIN in the last update. Do you have simply no QA at your company, or do you just not care?

    I have a 32" 4k monitor and a 15.6" 4K Notebook Monitor.
    If I set them both to 150%, I get the Excel spreadsheet opening within word "embedded" - as I would like to have it...

    ... OK, I can't read anything on my Notebook screen any longer as the content is all too small and I'm getting old, but hey-ho, it's only supposed to be a tool on which I perform my work, so no probs there! (facepalm).

    If I have two scales set on the two monitors, then the spreadsheet always opens in a separate instance of excel. Can you please explain to me what the scale of my Monitors has to do with how an embedded Excel spreadsheet opens in Word???

    So, to quote myself from >>2018<<...

    What would be good to understand is why this symptom occurs- as far as I was aware, I made no changes to my Office configuration. All I noticed was that after a reboot for updates, the behaviour of Word in this instance had changed.

    Maybe it was a bad move for MS to fire all the testers and try to substitute professionals with well-meaning amateurs ("insiders"); the product quality has taken a real nose-dive.

    I am patient and usually do not get annoyed, but I think this is just terrible and it is destroying my productive time.

    Please fix this AGAIN ASAP!

    John Mantle, QuantityWare GmbH

    Wednesday, February 19, 2020 12:52 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Still broken.

    John Mantle, QuantityWare GmbH

    Thursday, April 9, 2020 8:15 AM