Author Topic: Getting used to 2016 from 2010 - Embedded Excel worksheet question  (Read 163 times)

0 Members and 1 Guest are viewing this topic.

dsmall

  • Newbie
  • *
  • Posts: 5
Hi all, we have recently transitioned from 2010 to 2016 and still getting used to some of the differences, looking for feedback about embedding Excel worksheet in Visio.

Previously in 2010 I could highlight a group of cells and "Paste Special" into Visio.  Double clicking the Excel shape would open it up externally in Excel for editing.  Now in 2016 I do the same process but double clicking opens up an internal worksheet editor instead of Excel.  For a few reasons this is more limited and frustrating then editing externally.  Is there a way to force the worksheet to open in Excel?

Previously I had Office 2010/Visio 2010 but now have Visio 2016/Office 2016.

Thanks!

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3622
  • Ideas Visio-lized into solutions
Re: Getting used to 2016 from 2010 - Embedded Excel worksheet question
« Reply #1 on: July 18, 2019, 12:46:42 AM »
Searching the internet, this appears to be an Office 2016 installation problem, not a Visio 2016 issue.  To verify, try putting your Excel selection into Word or PP.  Then, double click.  Should see the same issue.   

See this:  https://answers.microsoft.com/en-us/msoffice/forum/all/office-2016-xls-file-wont-open-on-double-click/12504b15-4f53-4f3c-a691-723f2c38e5c3
Visio 2019 Pro

dsmall

  • Newbie
  • *
  • Posts: 5
Re: Getting used to 2016 from 2010 - Embedded Excel worksheet question
« Reply #2 on: July 18, 2019, 11:39:05 AM »
Thanks for the feedback!  Using the suggestion in the link I repaired my Office installation but the behaviour is the same.  I tried doing the same thing in Word and PP but both of those programs deal with Excel objects differently and was not able to replicate the issue.

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3622
  • Ideas Visio-lized into solutions
Re: Getting used to 2016 from 2010 - Embedded Excel worksheet question
« Reply #3 on: July 18, 2019, 01:18:58 PM »
I'm running V2019 Pro plus Office 10.  Copying a section of an Excel file, doing a paste special into V2019 or Word, closing the open Excel file, then dbl clicking the worksheet object in either Visio or Word opens the Excel app and the contents for editing.  This makes me believe that either Office16 behavior has been changed, or there's a bug, or there's perhaps a setting somewhere in the Office apps, e.g., Excel, that hasn't been set properly.

Pretty sure this isn't a Visio issue...don't recall it coming up on the forum before.
Visio 2019 Pro

dsmall

  • Newbie
  • *
  • Posts: 5
Re: Getting used to 2016 from 2010 - Embedded Excel worksheet question
« Reply #4 on: July 26, 2019, 03:19:04 PM »
After a bit more tinkering, I think I found the cause but still not a happy resolution.  If I right-click on the worksheet, navigate to "Worksheet Object", and choose "Open" it will open in Excel, success!  If I choose "Edit" it opens in Visio's worksheet editor, so double-clicking the worksheet must equal "Edit".  It would be great to change that to "Open" but if that's not possible at least I know a workaround now!