Microsoft KB Archive/72772

{| = DDE Error: Cannot Obtain Data from Excel Error Message =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q72772

SUMMARY
The error message &quot;Cannot Obtain Data From C:\Excel\sheetname!R1C1&quot; will occur when a document in Word for Windows has a hot link with an Excel worksheet and there is an .XLA (Excel add-in) or other file(s) in the XLSTART directory.

Workaround
Remove all .XLA files, or any other files from the XLSTART directory.

MORE INFORMATION
An Excel sheet can be linked to a Word for Windows document with a hot or a warm link. A hot link is created by clicking the Auto Update option in the dialog box that appears when you choose Paste Link from the Edit menu. When a hot link is created, reopening the document in Word for Windows will cause Word for Windows to automatically request the updated information from Excel by first starting Excel, then creating a DDE link to Excel for the original Excel sheet.

Having an .XLA file in the XLSTART directory will cause the DDE link to fail because Excel loads the file after the Excel executable has loaded and prevents Excel from completing the DDE channel with Word for Windows.

Workarounds
Take the XLA file out of the XLSTART directory or run Excel with the sheet open before opening the Word for Windows document.

Steps to Reproduce
 Put an XLA (add-In) file in the XLSTART directory. (Any file will do.) Start Word for Windows and Excel 3.00. Open a sheet in Excel. Select a cell and choose Copy from the Edit menu. Switch to Word for Windows. From the Edit menu, choose Paste Link and click Auto Update. Choose OK. Exit Excel. Close the document in Word for Windows, but leave Word for Windows running. Reopen the document in Word for Windows and choose Yes to start External Automatic Links.  Choose Yes when it asks Remote Data Not Accessible, Start Application Excel? The message &quot;Cannot Obtain Data From C:\Excel...&quot; appears.  Take the XLA file out of the XLSTART directory and repeat steps 6 and 7. Excel should now send the requested data.</li></ol>