dynamic connections in excel?

[dennism]

Hello,

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

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

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

Is there any standard-possibility to do that??

Thanks !

 

[Arvi Laanemets]

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.