Can Not Resize Embedded Excel Objects in Visio Plan 2

Anonymous
2021-10-20T16:59:14+00:00

Around the time Servicing Stack 10.0.19041.1220 was sent out on 9/24/2021 I was able to easily resize the viewing area of an imbedded Excel Object. After that, no matter what I tried, all imbedded excel objects (even from files 4 years old) opened up outside of Visio as a separate file instead opening inside of Visio. Of course Microsoft wont let me uninstall this update to double check if this is the issue (but I'm guessing it is).

I have searched through every online help ticket/website and nothing has fixed this problem. I have uninstalled.....reinstalled......changed every option I can think of/read online to change.....and nothing.

This is what an imbedded Excel Object looked like before when it correctly opened inside of Visio

This is what is does now........again I changed nothing......

I have inserted new and existing Excel files every way possible.....I've changed the behavior options in the Developer tab....everything.....

Computer Info

Edition Windows 10 Pro

Version 21H1

Installed on ‎12/‎15/‎2020

OS build 19043.1165

Experience Windows Feature Experience Pack 120.2212.3530.0

This is my Visio version

Microsoft 365 and Office | Visio | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes
Answer accepted by question author
  1. Anonymous
    2021-10-27T13:29:34+00:00

    In same thread i find solution

    I received a workaround from the Microsoft team:

    1. Go to excel. File->Options->General->when using multiple displays.
    2. Set it to 'Optimize for compatibility'.
    16 people found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Anonymous
    2021-10-21T02:31:38+00:00

    Hi,

    Welcome to Microsoft Community.

    From some tests, it seems like the same behavior also happens on our side with Visio version 2109(current channel) and 2111(insider beta channel). The inserted Excel workbook objects are not available for users to edit the data range inside the Visio app but it will open the Excel app separately.

    Hence, it seems like the behavior of editing an Excel workbook object in Visio has been changed in recent updated versions. For such a new feature design, it is suggested to submit your feedback in Visio apps to let the related product team get informed of the inconveniences it may have caused and provide a better experience for users. See: How do I give feedback on Microsoft Office?

    Really sorry that forum engineers here have no resources to the building of features in Office apps. Your understanding is highly appreciated and hope a nice day for you.

    Best Regards,

    Mia

    0 comments No comments
  2. Anonymous
    2021-10-22T14:03:44+00:00

    i shared my workaround in same thread


    May be this video can help ?

    https://youtu.be/PUovDAMMYj8

    Sorry for my terrible English

    0 comments No comments