PC Review


Reply
Thread Tools Rate Thread

Define Name reference

 
 
=?Utf-8?B?THAxMg==?=
Guest
Posts: n/a
 
      19th Feb 2006
Hi All,
I have two workbooks, One called Data.xls and the second is a template for
each branch we have.which is driven/generated from a intranet system in our
organization
The Branch WB has defined names(references) to the Data WB. The first time
i've created the templates i worked under 'My documents' folder. the users
that use both Temlates and Data files got the Defined Names reference to the
exact '<My username>/My Documents' folder and get the wrong data instead of
the place where they saved the WBs.
Is there a way for Excel to reference to the local Data.xls and not to the
original folder? If not is there any Alternative?
Thanks in advance
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reference/define last cell AG Microsoft Excel Programming 4 17th Jul 2008 03:41 PM
Is it possible to use a cell reference to define the database? =?Utf-8?B?UGVycGxleGVkaW5LWQ==?= Microsoft Excel Worksheet Functions 3 14th Nov 2006 09:00 PM
how do I define a chart series with an indirect reference =?Utf-8?B?dHZhbmVsbGVu?= Microsoft Excel Charting 4 31st May 2006 10:52 AM
Define and Reference fixed data in a table RedHook Microsoft Excel New Users 4 12th May 2006 04:56 PM
relative reference in a macro to define a name Hal Forman Microsoft Excel Programming 2 28th May 2004 07:13 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:59 PM.