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.
In Control Panel, search Associations
Open Default Programs
Associate a file type...
Make sure xls, xlsm etc are associated with Excel
Open Default Programs
Associate a file type...
Make sure xls, xlsm etc are associated with Excel
ASKER
They dont have time to try and save xls. They need IE to open the spreadsheet in Excel
ASKER
Gary, what should I do here? Im confused
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).
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).
ASKER
Oh sorry! Some are able to save the file as an xls. Sometimes it saves as https://oasbi1.it.xxx....
ASKER
We can use either IE 8 or 10 here
ASKER
Both have same symptoms
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
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
ASKER
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
ASKER
I noticed that some users' dialog boxes have the "Do not show this dialog again." checkbox, and some do not.
ASKER
I do not see excel in the Select your default program list
ASKER
Only OL and Onenote
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
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
ASKER
the end user says they have macros too. Does this matter at all?
ASKER
It appears all the 'x's are associated with excel
Then check the settings in PeopleSoft, maybe there is something there sending it directly to IE
ASKER
Tried it about a dozen times already
ASKER
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
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
ASKER
Tried all that too
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This fixed itself. Closing
ASKER
none
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?