News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Dynamic excel chart links become envelope shapes

Started by canadiense999, September 28, 2021, 05:04:28 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

canadiense999

Hello ...

I have Excel 365 and Visio 2019.  In Visio I have linked a number of charts in Excel that change daily.  I switched to the Technical Preview stream in Office recently.  Everything works, but now the Excel links are not always visible - they're replaced with what looks like envelopes.  Any idea why Excel charts linked in Visio are represented by envelope-looking boxes and how to get rid of that and return to a "live" update of the chart?

Thanks!

Surrogate

#1
Hi, from Russia !

Sorry, as i wrote early I am Russian. Not sure that i correct understand what do you mean as Excel Charts ?

cross-post

canadiense999

Hello Russia!

Open Excel, create a bar chart.  Copy it with CTRL-C.  Open Visio.  Right-click and Paste Special, choose Paste Link.

Then, whenever the chart changes in Excel, the Visio link changes.


Surrogate

You have a visio document that contains some embedded Excel charts. You implemented them some time ago. In those days you were using a different version of MS Excel. After upgrading/change your version of Excel did you encounter this problem?

canadiense999

Yes ... but not that long ago.  Now that's it's Excel "365" the version changes are transparent.

Maybe re-embed the charts?  The charts still refresh, but now they're a bit wonky. 

Surrogate


canadiense999

Nope.  Didn't work.  Still looks like this when I refresh.


canadiense999

My version:  Microsoft® Visio® 2019 MSO (Version 2109 Build 16.0.14430.20224) 64-bit


Surrogate

All know that when you add embed chart to visio document, visio engine write that this ole-object must be opened with current MS Office version. Often my colleges who used another versions of MS MS Office cant open and update ole-objects.

Right now you use web-based Excel version?

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 291 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1119KB.
Tokens: post-login.
Cache hits: 13: 0.00201s for 26,767 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]