PSS ID Number: 136316
Article Last Modified on 2/1/2002
The information in this article applies to:
- Microsoft Excel for Windows 95 7.0
This article was previously published under Q136316
SYMPTOMS
If you are using a non-English version of Microsoft Excel and you open a
workbook that contains a map that was created with Microsoft Data Map, you
may only be able to open other workbooks via the Open dialog box or by
dragging the file to Microsoft Excel. In addition, Microsoft Excel may fail
to respond to DDE commands sent to it by other applications.
CAUSE
This problem occurs because of the way in which Microsoft Data Map
communicates with Microsoft Excel 7.0. When you open a workbook that
contains a map, Data Map causes Microsoft Excel to accept incoming DDE
commands in English only (even if you are using a non-English version of
Microsoft Excel). This behavior continues even after Microsoft Excel has
finished processing information from Data Map. This behavior will prevent
Microsoft Excel from accepting most (if not all) incoming DDE commands.
When Microsoft Excel is in this state, you will be unable to open files
from any of the following locations:
- The Start menu (this includes openning files by clicking the Open Office
Document button).
- The Desktop, Explorer, or My Computer (either by double-clicking the
file on the Desktop or by double-clicking a shortcut that points to the
file).
WORKAROUND
To reset the DDE language settings for Microsoft Excel, exit and restart
Microsoft Excel.
NOTE: If you need to send DDE commands to Microsoft Excel, do NOT open
files that contain maps created in Microsoft Data Map.
To open a file in Microsoft Excel after a file containing a map has already
been opened, use either of the following methods:
Method 1: Use the Open dialog box:
- Click Open on the File menu, or click the Open button on the
Standard toolbar.
- Select the file you want to open, and then click Open.
Method 2: Drag the file to the Microsoft Excel window:
- From My Computer, Explorer, or the Desktop, select the file
you want to open and drag it to the Microsoft Excel title bar.
When the icon is over the title bar, release the mouse button
to drop the file. The file should be opened normally.
- If Microsoft Excel is minimized, drag the icon for the file
onto the Microsoft Excel button on the Taskbar. After a second
or two, the Microsoft Excel window will restore itself. You
can then drop the file on the Microsoft Excel title bar.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
Additional query words: datamap mapinfo foreign German French Italian foriegn dynamic data exchange
Keywords: KB136316
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch