Hello,

I have a question on "connections" in Excel. I want my data file to be
connected to a cell in an other data file. This is no problem.. but the
problem is that this connection will get a setted path, for example
C:/documents/target.xls

If I send the two documents to an other person now.. he oviously isn´t
able to see the connection because it is not really probable that he
has put the data in the same direction. So Excel doesn´t find the
connection.
He has to set the connection manual again.

So my question is, if excel is able to search the target-data on its
own - because it is really a lot of work to do it manually when you
have more than 30 datas on which you want to have access.

Is there any standard-possibility to do that??

Thanks !!


--
dennism
------------------------------------------------------------------------
dennism's Profile: http://www.excelforum.com/member.php...o&userid=27317
View this thread: http://www.excelforum.com/showthread...hreadid=468140

Hi

Do other users need to be connected to source file, or will having only
values be enough for them.

a) Open your workbook. Create an empty workbook. For every sheet needed to
be available by recipient, select whole sheet in original workbook and copy
it, and in new workbook, right-click on cell A1, and PasteSpecial
Values+Formats+ColumnWidths (and after that rename the sheet with same name
as in original workbook. When all needed sheets are copied, save the new
workbook and send it to recipient(s). In new workbook are only values - no
formulas, and no links to other workbooks.

b) Keep all workbooks which must be connected by several users, on shared
network resource (on server, or on another computer). Map this shared
resource, p.e. as X. Redesign all links in your original workbook, so they
look like
='X:\[SourceWorkbook.xls]SourceSheet'!A1
All recipients must also the same network resource been mapped in same way
(as X in my example). Now, when you send your excel workbook to them, they
can open it without any problems.


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"dennism" wrote in
message ...

Hello,

I have a question on "connections" in Excel. I want my data file to be
connected to a cell in an other data file. This is no problem.. but the
problem is that this connection will get a setted path, for example
C:/documents/target.xls

If I send the two documents to an other person now.. he oviously isn´t
able to see the connection because it is not really probable that he
has put the data in the same direction. So Excel doesn´t find the
connection.
He has to set the connection manual again.

So my question is, if excel is able to search the target-data on its
own - because it is really a lot of work to do it manually when you
have more than 30 datas on which you want to have access.

Is there any standard-possibility to do that??

Thanks !!


--
dennism
------------------------------------------------------------------------
dennism's Profile:
http://www.excelforum.com/member.php...o&userid=27317
View this thread: http://www.excelforum.com/showthread...hreadid=468140