Blog

[Excel] 3 Sections when the file cannot be opened

In this corner, we will introduce information useful for office work, such as the basic functions that Excel cannot hear and the super -speed tricks used by masters.

This time, I will introduce how to respond when the Excel file does not open.In Excel files, double -clicking the icon will automatically launch and deploy files, but in rare cases it will not open.In that case, please try the following procedure.

How to deal with the Excel file opens ①

Check the file name

If the file name contains "full -width" (double quotation), the program will start, but the file will not open. It may be that the file name has been accidentally changed without notice.Please change the file name so that "full -width" does not enter.

How to deal with the Excel file opens ②

Check the file extension

Exel files include ". XLSX", ".xls", ". XLTX", and ". XLSM".If this extension has changed, or if the Excel version is old, you may not be able to open the file.In Excel after Office Excel 2007, ". XLSX" is standard, but in Excel 97 -Excel 2003, ".xls" was a standard extension, so you may not be able to open a new extension file.In that case, rewrite the extension yourself, or ask the file creator to output it with ".xls".

To check the file extension, open "Customize Desktop" from "Control Panel" in the menu and select "Folder Options (or Explorer Options)".

Click the "Display" tab of the pop -up menu and remove the "No registered extensions" from the detailed settings.This will display the extension after the file name, so let's check it.

How to deal with the Excel file open ③

Change Excel DDE settings

The file is opened by double -clicking because the default programs and apps are determined by the type of file, and the extension .xlsx file is associated with Excel program.This association may not be opened and cannot be opened, but if an error is displayed as "an error occurred when sending commands to the program", DDE (Dynamic Data Exchange).It may be that the setting has changed."DDE" is the mechanism that opens the file by launching the program.An error may be displayed as "(file name) is not found ...".

In such a case, if you enable DDE, the file may open.To enable DDE, click "File" tab → "Option" on the Excel screen.On the "Excel Options" screen, select "Detailed Settings" → Uncheck "Ignore other applications using Dynamic Data Exchange (DDE)".

【エクセル】ファイルが開けないときの対処法3選

This allows you to use DDE.After completing Excel, try to double -click the file again to open it.

If the Excel file can no longer be opened, please try it in the above manner.

Related article EXCEL Files Open in an instant 3 Super Speed Open Waza 3 Select EXCEL Instant Start Starting Three Selections

続きを読む

Hot Articles

How to Save Websites as PDF on iPhone or PC | Business Insider Japan

How to Save Websites as PDF on iPhone or PC | Business Insider Japan

Sign up for a free e-mail newsletter We'll send you a Business Insider Japan e-mail newsletter at 17:00 on weekdays. Check the terms of use You can save the website as a PDF from various web browsers including Safari on iPhone. Photo: Takuma Imamura Web page suddenly ...

READ MORE READ MORE
Yahoo! News Digitalizing the traditional "small pattern dyeing" pattern Crisis of disappearance, challenge of long-established president

Yahoo! News Digitalizing the traditional "small pattern dyeing" pattern Crisis of disappearance, challenge of long-established president

In the file in front of Mr. Atsushi Tomita, a well-preserved paper pattern is included so that it is not exposed to the air as much as possible. To prepare for digitization and prevent deterioration = Taken by Hiroyuki Kondo on the morning of December 10, 2021 at Tomita Dyeing Crafts in Shinjuku-ku, Tokyo ...

READ MORE READ MORE
 It's okay if you forget to record the news!How to see the famous scenes of the Olympics later on your smartphone

It's okay if you forget to record the news!How to see the famous scenes of the Olympics later on your smartphone

Explaining how to use the archive distribution The Tokyo Olympics attracts attention not only for players' play but also for unique commentary. Even if you miss it even though it became a hot topic, or if you did not record it, you can do it at your favorite timing later ...

READ MORE READ MORE