GUINNESS85
New Member
- Joined
- Aug 11, 2011
- Messages
- 7
<HR style="COLOR: #ebebeb; BACKGROUND-COLOR: #ebebeb" SIZE=1> <!-- / icon and title --><!-- message -->
<!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --><!-- END TEMPLATE: ad_showthread_firstpost_start -->I am working with files that are on a network shared drive and I have my UDF saved properly as an add-in on my computer. However whenever I move© my master sheet into another workbook the below happens...
=INDIRECT(GlobalLookup()) (what it should say)
=INDIRECT('O:\Documents and Settings\jujackso\Application Data\Microsoft\AddIns\5B AUTO CALC DEMO.xla'!GlobalLookup()) (what comes up when I open on shared drive)
Why is it adding this path, it does not even exist... How do i make this never happen?
<!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --><!-- END TEMPLATE: ad_showthread_firstpost_start -->I am working with files that are on a network shared drive and I have my UDF saved properly as an add-in on my computer. However whenever I move© my master sheet into another workbook the below happens...
=INDIRECT(GlobalLookup()) (what it should say)
=INDIRECT('O:\Documents and Settings\jujackso\Application Data\Microsoft\AddIns\5B AUTO CALC DEMO.xla'!GlobalLookup()) (what comes up when I open on shared drive)
Why is it adding this path, it does not even exist... How do i make this never happen?
