Avatar of E=mc2
E=mc2
Flag for Canada asked on

Microsoft Excel cannot access the file, how to resolve this?

I am using a website, and there is an export function to export a file.
In the past, on a different computer, the export function would result in an Excel file which Excel could open.

This is what the message looks like:
Microsoft Excel cannot access the file
'https://....../file.ibfs?........ .xmh'.
There are several possible reasons:
- The file name or path does not exist.
- The file is being used by another program.
- The workbook you are trying to save has the same name as a currently open workbook.


Using internet Explorer 8, and Office 2010 is installed on the computer.
Internet Explorer 8 is needed on this computer albeit it is old, but needed since a website which is visited requires the older browser.

What can be done in order to correct this so that Excel is able to open the file automatically?
(Currently, if I export the file and save it and change the extension to .xls, I can then open it in Excel.
I want to avoid this and simply have Excel recognize the file being exported and open it, perhaps even without saving it).
Is this possible?

Thanks in advance for your assistance.
Microsoft ExcelWeb Languages and StandardsWeb Development

Avatar of undefined
Last Comment
Justin Pilditch

8/22/2022 - Mon
Benjamin Voglar

Did you mean XML?
Benjamin Voglar

E=mc2

ASKER
@Benjamin Voglar - Thanks, however it's an .ibfs extension or even perhaps an .xmh  - it does not say .xml.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Justin Pilditch

.ibfs is the extension of the server page that is initiating the download

I'm curious why Excel is effectively saying it can't open a web page - where does the file download to and can you manually open it from there? As in, FILE / OPEN and navigate to the downloaded file
E=mc2

ASKER
My understanding is that in the past, on another computer, the file which was being formed was a file that could be open with Excel.
Justin Pilditch

When you try to download the file, can you select SAVE rather than OPEN? Then go into Excel and do FILE/OPEN...

Or, as Benjamin has already suggested, you could associate .xmh files with Excel and try again.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
E=mc2

ASKER
You can Save, rename the file to an .xls and open with Excel.  However I want to avoid this and have Excel recognize the file and open it automatically.
Justin Pilditch

OK, so Excel can recognise the file contents - that's good.

All you need to do is to tell this particular machine to associate .XMH files with Excel and that is what will happen. If you move to another computer you will need to set up the association on that one as well.

Fear not - it is a simple process - just follow the instructions in the links in Benjamin's post above for your version of Windows. You'll know if it has worked by double clicking the file - if OK then Excel will open the  file automatically

If you get stuck, do come back to us. :)
E=mc2

ASKER
Thanks, however .xmh is not showing up in the list of files that I can associate programs with.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
Justin Pilditch

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
E=mc2

ASKER
Thanks.
Associating .xmh to Excel does not work unfortunately.
Justin Pilditch

What happens when you do a RIGHT-CLICK and select OPEN now? Do you see any message?

(FYI I created a test file and associated it with Excel so now when I double click it or right-click and open, the files is opened in Excel)