We help IT Professionals succeed at work.

IE 8 wont allow excel spreadsheet to open in excel

744 Views
Last Modified: 2014-09-20
Hi techs I have an issue at work where those who are trying to open a spreadsheet from within PeopleSoft cannot open it in Excel and instead it opens in a browser.  This is now happening with at least 5 or 6 of my end users.  I have tried everything I know to fix this. the people soft team says its windows 7.  I've tried office repairs, settings in Internet Options, and several other things but nothing works.  Assistance is appreciated thank you.
Comment
Watch Question

RayData Analyst

Commented:
Please describe exactly what steps are being taken and exact file extension.

To help diagnose, if a user were to right click the file, select 'save as', save it to their desktop, then double click the file from the desktop; what happens then?
CERTIFIED EXPERT
Expert of the Year 2014
Top Expert 2014

Commented:
In Control Panel, search Associations
Open Default Programs
Associate a file type...
Make sure xls, xlsm etc are associated with Excel
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
They dont have time to try and save xls.  They need IE to open the spreadsheet in Excel
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Gary, what should I do here?  Im confused
RayData Analyst

Commented:
I didn't suggest it as a work around.  I suggested it as a diagnostic tool so you could verify that the file opens with Excel when not being handled in the web browser.  This will direct you to where the solution needs to happen.

If it will open in Excel after doing a file save as like I described, then it is 100% a browser settings issue.  If not, then the suggestion by Gary would be the fix.

We will likely need to know what browser you are using as well (Internet Explorer, firefox, chrome, safari, opera, etc).
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Oh sorry!  Some are able to save the file as an xls.  Sometimes it saves as https://oasbi1.it.xxx....
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
We can use either IE 8 or 10 here
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Both have same symptoms
CERTIFIED EXPERT
Expert of the Year 2014
Top Expert 2014

Commented:
When you have clicked Default Programs
Click Set your default programs
Select Excel on the left
On the right click Set this program as default
You can also double check what file types it will open by clicking Choose defaults for this program
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
They need to be able to click the hyperlink in Peoplesoft to the file and have it open in Excel, not in the IE browser
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
I noticed that some users' dialog boxes have the "Do not show this dialog again." checkbox, and some do not.
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
I do not see excel in the Select your default program list
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Only OL and Onenote
CERTIFIED EXPERT
Expert of the Year 2014
Top Expert 2014

Commented:
That is the only two programs you see in the list?

In Control Panel, search Associations
Click Open Default Programs
Click Associate a file type or protocol with a specific program
Scroll down to the xls, xlsm etc extensions.
Click one and click the Change program button.
If Excel is not in the list of programs then browse to the file and select OK.
Do the same for each of the extensions beginning with x
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
the end user says they have macros too.  Does this matter at all?
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
It appears all the 'x's are associated with excel
CERTIFIED EXPERT
Expert of the Year 2014
Top Expert 2014

Commented:
Then check the settings in PeopleSoft, maybe there is something there sending it directly to IE
CERTIFIED EXPERT

Commented:
Try this Microsoft Fix it.

http://support.microsoft.com/kb/162059
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Tried it about a dozen times already
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
The people soft team says it has nothing to do with PeopleSoft so they won't check the settings but if there were settings I don't know which ones they would check.
Have you tried this: (http://erptraining.niu.edu/erptraining/PS_browser_settings/ie8.shtml#excel)

View Excel files in Excel instead of a browser window

Open the Browser
Select Tools from the Menu toolbar
Select Internet Options
Select the Advanced tab
In the Browsing section, uncheck the Reuse windows for launching shortcuts
(when tabbed browsing is off)
Click OK

University of Akron seems to have an exhaustive document on PeopleSoft and IE8:
https://www.uakron.edu/dotAsset/0d12c1b1-7123-489c-aff9-45c809b12821.pdf

as does Duke University:
http://sissoffice.duke.edu/docs/IE8%20fix%20for%20download%20to%20Excel%20icon%20to%20work.pdf
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
Tried all that too
Dispatch Software Support and Server Administration
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
This fixed itself.  Closing
Mark O'BrienDispatch Software Support and Server Administration

Author

Commented:
none

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.