Excel file needs to open in Excel, not Excel Viewer
Solution 1:
As paulmorriss pointed out, you should tell us what happens when you open a file from the Windows Explorer.
Yet, I've never seen an option where Outlook would open files with another program than the Windows Explorer.
Here is what you (or whoever has the same problem) can try:
- save your file to your Desktop
- hold SHIFT while right-clicking the file
- from the
Open With
list, selectChoose Program
and select Excel - make sure that you also check the box
Use this program as the default
The next time you open such a file type, it should open directly with that program (even from Outlook).
If you still have this issue, tell us your version of Windows and eventually Excel.
Solution 2:
Assigning File Extensions to Programs
- Click on your Start Menu. In the search bar type "Default Programs" and hit enter.
- The second option should be "Associate a file type or protocol with a program".
Microsoft Excel's most common file extensions are .xls, .xlsx, .xlm, and .xlsm.
- Scroll down toward the bottom where you will find the above mentioned extensions.
- Select the extension you wish to assign to Excel.
- In the upper right area of the window select "Change program".
- Select Microsoft Excel from the list of programs.
- Hit OK
If Microsoft Excel is not in the list of programs to choose from, select "Browse" and rows to the install folder of Microsoft Excel and select the program from there.
For example: C:\Program Files (x86)\Microsoft Office\Office14
This Method will allow you to assign any file type to the Application/Program of your choice.
Solution 3:
If this is a custom operating system as in a government department installed but reduced version of windows due to the many security issues with all the versions. Then you might have to look at creating a macro that dumps the file in your outlook to a shared drive that you can access from any computer on your network. I had to do this once. You need to make sure that it leaves a "virtual path link" to the attachment and drive in question in html format. If you do not want to do this then.
You might want to
- remove the viewer software
- repair/reinstall your version of ms office you are running
- make sure that you are allowed to make these changes to the system you are on
- If all previous are unavailable to you as options then try the assign default file types
- check with IT admin to make sure its ok for you to build VBA to dump these files to a network drive.
If you do go with the option to dump the files you will see a good speed increase in your outlook. Here is a good example of this