XLSM FILES WON'T OPEN IN 365

dhd71

New Member
Joined
Feb 15, 2021
Messages
11
Office Version
  1. 365
Has anyone been able to figure this out yet? I started with a new company recently. My old company used an EXCEL based box making program created by the owners son. It works fine on my home computer running office 2010 but at my new company using office 365 it won't open. Just says the file is corrupted. I know it's not because I can take it back home and the same file on the thumb drive opens up perfectly, no issues. I figured it was just a macros permission issue but I changed all that and it still doesn't work. Anyone have any ideas? Any help would be greatly appreciated.

Thank you
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,974
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
The file definitely seems corrupted when opening with Excel. What is the name of the macro in the file?
 
Last edited:

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

psycoperl

Active Member
Joined
Oct 23, 2007
Messages
287
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
  3. Web
I just tried to open the file
and received "Excel cannot open the file 'BOX MAKER PROGRAM.xlsm' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file." I am using Excel 2016 Mac

I also tried it in Office.com's Web Version of Excel and it stated "We're sorry, we couldn't open your workbook. It's possibly corrupt"
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,974
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
I got the same response but I think I managed to open it in a cheating way which is why I asked for the name of the macro to double check it was the same file.
It doesn't really make any difference though as the file has got corrupted and you will need to rebuild it or save a new copy as you obviously have a version on your home computer.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,402
Messages
5,624,532
Members
416,032
Latest member
dunhamsasphalt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top