Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-12-2020, 02:50 AM
Scaffold Scaffold is offline Sheet.<id> reference does not work Windows 10 Sheet.<id> reference does not work Office 2016
Advanced Beginner
Sheet.<id> reference does not work
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Angry Sheet.<id> reference does not work


Hello everyone!
I was trying to reference shape custom cells by using she Sheet.<id> reference I read about in different places. However, it does not work. I just get no prompts when I attempt to write formula and Visio keeps telling me there is an error in the formula, no matter what. What can be the reason? Is it something to do with a localized version of Visio? Any ideas? The ultimate aim I am after is to make text field inside the shape to display the text defined in the custom cell of a shape itself.

Reply With Quote
  #2  
Old 03-12-2020, 07:49 PM
Guessed's Avatar
Guessed Guessed is offline Sheet.&lt;id&gt; reference does not work Windows 10 Sheet.&lt;id&gt; reference does not work Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

If your shape contains a User-Defined cell then you show that in the text by right clicking and going to Insert Field > Category=User-defined Cells. You then pick the relevant field name from the list.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 03-13-2020, 12:19 AM
Scaffold Scaffold is offline Sheet.&lt;id&gt; reference does not work Windows 10 Sheet.&lt;id&gt; reference does not work Office 2016
Advanced Beginner
Sheet.&lt;id&gt; reference does not work
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Default

Yes, I know. The problem that it works only when you're linking from the same object. If you must link across objects, you need a compound reference - as far as I know.
Reply With Quote
  #4  
Old 03-13-2020, 08:01 PM
Guessed's Avatar
Guessed Guessed is offline Sheet.&lt;id&gt; reference does not work Windows 10 Sheet.&lt;id&gt; reference does not work Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

In that case, try something along the lines of
=Sheet.x!Prop.Row_1
= Sheet.x!User.MyProperty
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
from paper to work sheet Olinoxy Excel 1 03-25-2017 07:39 AM
Sheet.&lt;id&gt; reference does not work Updating actual work and work on resource spread sheet Campelliann Project 3 01-31-2017 11:17 AM
Sheet.&lt;id&gt; reference does not work Using Cell Values in Active Sheet to Populate Path to External Reference Link wowcrofty Excel 4 12-19-2016 12:29 PM
Sheet.&lt;id&gt; reference does not work Circular Reference Warning in Excel Sheet. Rahmat_uk20 Excel 3 06-08-2012 02:31 AM
Sheet.&lt;id&gt; reference does not work Good book other reference work on VBA Jennifer Murphy Word VBA 1 01-30-2012 10:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft