Thanks, but is there an answer to the fact that my imported Excel
Spreadsheet docs have many links that worked between documents, but
weren't DDE, so now don't link unless I change all the formulae? In
other words can I mass update my links??
Brian wrote:
Nick Cooper wrote:
When you have used the Excel technique (same as me) how does the
formula in the formula bar of your result cell look? Does it start:
{=DDE("soffice",....
or does it start:
='file:///...
Reason for asking is that I get the link to work automatically when I
make the link by doing:
Source cell: Ctrl+C
Result cell: Paste special
This then makes the link a DDE link [{=DDE("soffice"] which updates
automatically as I want.
Aha!,
We have been looking at different things.
When you said "sheet" I presumed you meant sheet as in a sheet
(sheet1, sheet2, etc) in a spreadsheet document.
From the above I see you mean another spreadsheet ???
As you say, Copy (or Ctrl+C) and Paste Special => Link will give you
an updated link between documents. The formula bar shows
{=DDE("soffice";" ... and the link updates automatically provided you
don't move or rename the source file.
"=" => source document => <enter> gives='file:///... in the formula
bar and no updating
Trouble is I don't want to go through all my old Excel sheets
re-doing all the links to be DDE.
Does anyone know if there's a setting that will make all links DDE?
Not me, maybe someone else ???
Brian
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Nick Cooper
Financial Director
Rohde Shoes (UK) Limited
Tel: 0116 260 8011
Fax: 0116 260 6954
This e-mail message and any files transmitted with it are confidential and for
use by the intended addressee only. If you received this information in error,
you should reply to the sender immediately and delete the material from any
computer that may contain it and destroy any printed copies you may have made.
We do not accept responsibility for changes made to this message after it was
sent.
Whilst all reasonable care has been taken to avoid the transmission of viruses,
it is the responsibility of the recipient to ensure that the onward
transmission, opening or use of this message and any attachments will not
adversely affect its systems or data. No responsibility is accepted by Rohde
Shoes (UK) Limited in this regard and the recipient should carry out
appropriate virus and security checks.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
