The file does not exist when loading in Excel

Asked By 50 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Holloway Hively
Answered By -10 points N/A #141075

The file does not exist when loading in Excel

qa-featured

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.

Answered By 0 points N/A #198483

The file does not exist when loading in Excel

qa-featured

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.

Best Answer
Best Answer
Answered By 0 points N/A #141076

The file does not exist when loading in Excel

qa-featured

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.

Answered By 574145 points N/A #311437

The file does not exist when loading in Excel

qa-featured

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”.

Login/Register to Answer

Related Questions