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

=GetVal(Prop._VisDM_F1) does not refresh even though F1 External Data does

Started by nlagerwey, December 14, 2011, 08:13:38 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

nlagerwey

I have a plug in to Visio (LeanView) that has proprietary shapes that I am trying to pull in external values to. 

It works one time with =GetVal(Prop._VisDM_F1) but when I use Refresh All it only refrershed the External Values (F1) but not the GetVal function.  If I go into the field on the Shape Sheet where this formula is located and go into the formula (F2) and hit enter, then it updates.....Is there a way I can automatically have the GetVal function refresh when I refresh the external datalink?

Thanks & Happy Holidays

gwideman

Hi nlagerwey. Don't know if you have solved your problem yet, and your question doesn't contain quite enough info for me to be sure of the answer. 
However, a couple of clues.  It's possible that the DEPENDSON function might help out with this problem, so take a look at the docs fir that:
http://msdn.microsoft.com/en-us/library/ff767396.aspx

If the problem is that some external data has updated, and the shapesheet didn't notice at all, then this is not so much a problem a shapesheet problem, but rather a general problem of notifying the drawing to re-read the external data source and update its calculations.  In that case, once you identify some mechanism for noticing that external data has changed then you can use that mechanism to change some cell in the drawing (perhaps "User.ExternalDataChanged" on the page or document sheet), and use DEPENDSON in relevant cells to reference that "User.ExternalDataChanged" cell, so they recalc.
Hope that helps,
Graham

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: 152 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1060KB.
Tokens: post-login.
Cache hits: 13: 0.00209s for 26,726 bytes (show)
Cache misses: 2: (show)
Queries used: 15.

[Show Queries]