The file does not exist when loading in Excel

Asked By doriswneil 50 points N/A Posted on - 05/28/2013

Hello,

Fellow Techyv members. I just saved my xls file yesterday after finalizing it. I try to open the file with Excel and I'm having an error message "Cannot open file, the file does not exist". Does it mean that I haven't saved it? I have Microsoft Excel 2010 on Windows XP 64 bit. 

Thanks.

• Status: Open
• Question Views: 942
• Answer Count: 4
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Holloway Hively

Go To Solution

Answered By Mills Fullwood 0 points N/A #141075

The file does not exist when loading in Excel

Hi,

The message you got could mean a number of things, either you did not save the message or that you are using a DDE to open the Excel file. When using DDE to open the excel file, such a message is bound to appear. To solve this problem you have to add a SLEEP function just before another DDE command can appear. You can get more information on how to about this on the http://support.sas.com/kb/32/672.html website.

About Mills Fullwood

Questions
4

Answers
112

Best Answers
14

• Vote Up 0 Vote Down

• Posted on - 05/28/2013
• Question Category: MS Excel

Answered By Huffman Serafin 0 points N/A #198483

The file does not exist when loading in Excel

Hi Doriswneil,

It seems that you are opening the file through the MS Excel application and you are choosing on the recent documents list, those list aren't well updated for it tracks the previous location of the save file before, try locating the file first and double click it to open it on MS Excel.

About Huffman Serafin

Questions
0

Answers
326

Best Answers
60

• Vote Up 0 Vote Down

• Posted on - 05/29/2013
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Holloway Hively 5 points N/A #141076

The file does not exist when loading in Excel

Hi Doriswneil,

Possibly, you might not save it properly. The file has been corrupted thus this error message appeared. You mentioned that you have created an Excel file using Microsoft Excel 2010. Have you tried to "Save-As" the file then select the option ".xls" for the file type. If you edit the file extension after saving it, this may affect the workbook.

I suggest that you should do these steps:

• Open the Microsoft 2010 Eixcel then open the workbook from there.
• Modify the file extension of your workbook – from ".xls" to ".xlsx" then vice-versa.

Hope this helps you in your current issue.

About Holloway Hively

Questions
2

Answers
102

Best Answers
45

• Vote Up 0 Vote Down

• Posted on - 05/29/2013
• Question Category: MS Excel

Answered By Sharath Reddy 590495 points N/A #311437

The file does not exist when loading in Excel

If you cannot open the file you created earlier, check the location of the file where you save it. You can get that error when you click the file in Microsoft Office Excel’s “Recent Documents” pane and you move the file to another location or you rename it.

Every file you open in Microsoft Office Excel appears in the “Recent Documents” pane when you click “File” or the Office Button. The items on the pane appear based on the file’s location when it is opened.

If the file was previously opened then you move it to a different folder or drive and you open it again, it will have a second or third entry in the “Recent Documents” pane all with the same name.

Now, when you click the old entry of the file in the “Recent Documents” pane and you know the file was already moved to a different folder or drive, you will get the error. To fix the problem, click the Office Button or “File” then select “Open” or press CTRL + O to bring up the “Open” dialog.

On the next screen, navigate to the location of the file where you save it, select the file, and click “Open”.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 09/03/2018
• Question Category: MS Excel