Troubleshoot opening files

Microsoft Office Excel 2003

ShowThe file may be damaged

The file you are trying to open may be damaged. Your Microsoft Office program may let you try to recover the text from the damaged file, or if recovery doesn't work, you can delete the damaged file and open a backup copy.

ShowHow?

  1. If the Microsoft Office program you are using is not responding, recover the program.

    ShowHow?

    1. On the Microsoft Windows Start menu, point to Programs, point to Microsoft Office Tools, and then click Microsoft Office Application Recovery.

    2. In the Application list, click the program or document that is not responding.

    3. Do one of the following:

      • To attempt to recover the files you were working on, click Recover Application or Restart Application.

      • If you just want to close the program, and lose recent changes to the files, click End Application.

    4. The error that caused the problem can be reported to Microsoft for use in improving future versions of the program. Click Report problem or Don't report problem.

  2. Open the Office program.

  3. Review the files listed in the Document Recovery task pane, and decide which to keep.

    ShowHow?

    • If a file has [Recovered] in the title it is usually a file that contains more recent changes than a file with [Original] in the title.

    • If you want to view what repairs were made to a file, point to the file in the Document Recovery task pane, click the arrow next to the file's name, and then click Show Repairs.

    • If you want to review the versions that were recovered, open all of the versions and save the best one.

  4. For each file you want to keep, point to the file in the Document Recovery task pane, click the arrow next to the file's name, and then do one of the following:

    • To work with the file, click Open.

    • To save the file, click Save As, and then enter a name for the file. By default, the file is saved in the same folder as the original file. If you use the same name as the original file, the original is overwritten. When you see a message asking whether you want to replace the existing file (with the changes you made up to the last time you saved the file), click Yes.

  5. When you have opened or saved all of the files you want to keep, click Close in the Document Recovery task pane.

ShowThe file name may be too long

The file name and the path name cannot exceed 223 characters. Do one of the following:

  • Shorten the file name.

  • Move the file to another folder that will shorten the path name.

Try to open the file again.

ShowThe disk the file is on may be too full

Try moving files to another disk to make more space available.

ShowThe Open dialog box doesn't list the file I'm looking for.

ShowCheck the file type

Make sure you have the correct file type selected in the Files of type box. You can also use *.* to show all files.

ShowConduct a search

In the Open dialog box, type the name of the file in the File name box, click Tools, and then click Search. Select criteria and then click Search.

ShowCheck the search criteria

  • When doing a search, make sure the entries in the Search dialog box are appropriate for the files you're searching for. To clear all current search criteria except the file location, and to reset to the default file type, click Restore.

  • Make sure you're looking on the correct drive and in the correct folder. If you don't know the folder name, you can search all folders and subfolders on the specified drive by selecting the appropriate drive in the Search in option.

ShowCheck the network connection

If you're looking for a file on the network and the network drive doesn't appear in the Open dialog box under Look in, do the following:

  1. Click Tools, and then click Map Network Drive.

  2. In the Drive box, click the drive letter you want to use to connect to the network.

  3. In the Folder box, enter the path where the file is located on the network.

    ShowTip

    You can also look for files on a network drive if your network supports the UNC. Just type the UNC path in the File name box in the Open dialog box— for example, type \\plans\documents.

ShowLook on the network or the Web

If you're looking for files on a Web server, type the folder path in the File name box in the Open dialog box— for example, type http://myserver/public.

ShowThe password I typed to open a file doesn't work.

Make sure you enter the correct username and password and that the CAPS LOCK key is not on. If you still cannot access the network server, consult your network administrator.

ShowThe shortcut to my file doesn't work anymore.

ShowThe file may have been renamed or deleted.

The shortcut will not work if there has been any change to the target file's name or extension. Use the Microsoft Office Search feature to look for files that have similar names or that were created or modified on the same date as the file you are trying to open.

Show How?

  1. Click Open Button image.

  2. Click Tools in the Open dialog box, and then click Search.

  3. Do one of the following:

    ShowSearch for a file containing specified text

    You can find a file containing text in its title, contents, or properties.

    1. On the Basic tab, in the Search text box, type the text to search for in Microsoft Office files, Web pages, and Microsoft Outlook items.

      ShowTip

      You can use wildcards in the Search text box. Type a question mark (?) to match any single character, or type an asterisk (*) to match any number of characters. For example, s?t finds "sat" and "set"; s*d finds "sad" and "started."

    2. To limit where to search, in the Search in box, select one or more drives, folders, Web sites, or Outlook mailboxes. To search everywhere, select Everywhere. To specify a single location, type it directly in the Search in box.

    3. To limit the types of search results, in the Results should be box, select the types of items to find. To find all types of files, Web pages, and Outlook items, select Anything.

    4. Click Search.

      ShowTip

      To view all properties of a found item, click the command button following the item, and then choose Properties.

    ShowSearch for a file based on one or more properties

    1. On the Advanced tab, enter one or more search criteria.

      ShowHow?

      1. In the Property box, choose a property from the list or type in a property name. The Property box displays the properties available in the currently open document.

        ShowTip

        You can use wildcards in the Property box. Type a question mark (?) to match any single character, or type an asterisk (*) to match any number of characters. For example, s?t finds "sat" and "set"; s*d finds "sad" and "started."

      2. In the Condition box, choose a condition from the list, or type in a condition.

      3. In the Value box, enter the value to associate with the condition.

      4. If previous search criteria exist, click And to add a criterion that must be true in addition to previous criteria. Click Or to add a criterion that is sufficient regardless of previous criteria.

      5. Click Add to add the search criterion.

        Note   If the value is invalid for the condition or property, the Add button is unavailable.

    2. To limit where to search, in the Search in box, select one or more drives, folders, Web sites, or Outlook mailboxes. To search everywhere, select Everywhere. To specify a single drive, folder, or Web site, type it directly in the Search in box.

    3. To limit the types of search results, in the Results should be box, select the types of files, Web pages, and Outlook items to find. To find all types of files and items, select Anything.

    4. Click Search.

      ShowTip

      To view all properties of a found item, click the command button following the item, and then choose Properties.

ShowThe file may be temporarily unavailable.

  • If the file is located on a network server, consult your network administrator to find out if the server drive is unavailable.

  • If the file is located on removable media such as a floppy disk, make sure the media with the target file is properly inserted in the drive or device.

ShowWhen I open a Web page in Excel, nothing appears.

If you use Microsoft Excel to open a Web page that was not created in Excel, but nothing appears, the Web page might contain a frames page. A single Web page can be divided into sections that each display separate Web pages; each of these sections is called a frame. The container that hosts the group of frames is called a frames page. Excel cannot open a Web page that contains a frames page.

If you know how to work with HTML source code, you can use an HTML editor to copy the information you want, without the frames page code, to a new file, and then open the new file in Excel.

ShowMy workbook opens with a read-only restriction.

One or both of the following may be true.

  • The creator of the workbook may have set a restriction so that the workbook can be opened only as read-only. Contact the creator of the workbook for more information.
  • If you try to use a version earlier than Microsoft Excel 97 to open a workbook from Excel 2000 or a later version of Excel, the workbook appears to be password-protected so that you can only open it as read-only. To open and save the workbook, use Excel 97 or later.

ShowWhen I start Excel by using a shortcut or icon, the default working folder is not correct.

If you start Microsoft Excel by using a shortcut, the working folder you specified for the shortcut might not be used. (This is the location you specified by right-clicking the shortcut icon, clicking Properties on the shortcut menu, and filling in the location in the Start in box on the Shortcut tab.) If a folder is set in the Default file location box on the General tab in the Options dialog box (Tools menu), Excel uses this location as the working folder.