Open PSV Files in the Same Excel 2010 Instance
Question details
The user wants pipe-delimited PSV files to open in the existing Excel 2010 instance.

- Product
- Microsoft Excel 2010
- Device & OS
- Windows 7
- Scenario
- Opening a PSV file from Windows while Excel is already running.
- Observed behavior
- PSV files open in a new Excel instance, while other Excel-associated file types open in the current instance.
Confirm that the file has a .psv extension and that Excel 2010 is already open. Note whether you are opening the file by double-clicking it in Windows Explorer.
Allow DDE requests in Excel 2010
Change Excel's DDE setting and test whether PSV files open in the existing instance.
In Excel 2010, click File > Options.
Select Advanced, then scroll down to the General section.
Clear “Ignore other applications that use Dynamic Data Exchange (DDE)” and click OK.
Close and reopen Excel, then double-click the PSV file in Windows Explorer to see whether it opens in the existing instance.

Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and support for common Excel formats, making it easier to move existing spreadsheets to WPS. It does not change Excel's DDE settings.

Frequently Asked Questions
Where is the DDE setting in Excel 2010?
Open File > Options > Advanced and scroll to General. Clear “Ignore other applications that use Dynamic Data Exchange (DDE)” and click OK.
What if the DDE option is already unchecked?
Check the PSV association by right-clicking the file in Windows Explorer and selecting Open with > Choose default program. Verify that Microsoft Excel is selected, then test the file again.
Does this setting control how pipe-delimited data is separated?
No. The DDE setting affects communication with other applications, not the delimiter used to read the file. To import the data, use Excel's Data > From Text and select the pipe character as the delimiter.
Will WPS Office change Excel's DDE behavior?
No. WPS Office is an alternative spreadsheet suite; change the DDE option in Excel itself to troubleshoot Excel's instance behavior.




