[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 722
  • Last Modified:

IE 8 wont allow excel spreadsheet to open in excel

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.
0
Mark O'Brien
Asked:
Mark O'Brien
  • 17
  • 4
  • 2
  • +2
1 Solution
 
RayData AnalystCommented:
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?
0
 
GaryCommented:
In Control Panel, search Associations
Open Default Programs
Associate a file type...
Make sure xls, xlsm etc are associated with Excel
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
They dont have time to try and save xls.  They need IE to open the spreadsheet in Excel
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Gary, what should I do here?  Im confused
0
 
RayData AnalystCommented:
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).
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Oh sorry!  Some are able to save the file as an xls.  Sometimes it saves as https://oasbi1.it.xxx....
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
We can use either IE 8 or 10 here
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Both have same symptoms
0
 
GaryCommented:
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
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor 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
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
I noticed that some users' dialog boxes have the "Do not show this dialog again." checkbox, and some do not.
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
I do not see excel in the Select your default program list
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Only OL and Onenote
0
 
GaryCommented:
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
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
the end user says they have macros too.  Does this matter at all?
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
It appears all the 'x's are associated with excel
0
 
GaryCommented:
Then check the settings in PeopleSoft, maybe there is something there sending it directly to IE
0
 
Ejgil HedegaardCommented:
Try this Microsoft Fix it.

http://support.microsoft.com/kb/162059
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Tried it about a dozen times already
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor 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.
0
 
Julie ThomasCommented:
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
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Tried all that too
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
On one eu with IE 8 I didn't make any changes and it suddenly fixed itself.  On another eu I installed IE 10 and hers is working.  This is REALLY frustrating with all the unknowns.
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
This fixed itself.  Closing
0
 
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
none
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 17
  • 4
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now