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
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,459
Office Version
  1. 365
Platform
  1. Windows
Maybe it's got some protection, to stop unauthorised use.
 

dhd71

New Member
Joined
Feb 15, 2021
Messages
11
Office Version
  1. 365
Maybe it's got some protection, to stop unauthorised use.
No, I used it at my old company. I made a copy and used it on my computer at home and I have used it on other computers. It's something to do with 365 or anything after 2010 versions of excel. I've seen threads of others struggling with the same issue after 2016 came out. Unfortunately, none found a solution or at least none posted a solution.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,974
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Did you download it (either from the web or an email)?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,459
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

In that case it depends on the code. There is no real reason, other than that, for the files not to open.
 

dhd71

New Member
Joined
Feb 15, 2021
Messages
11
Office Version
  1. 365
In that case it depends on the code. There is no real reason, other than that, for the files not to open.
Shouldn't it just be opening in compatibility mode? That's what it does on my home computer running office 2010
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,459
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

An xlsm file shouldn't open in compatibility mode, only old style xls should.
 

dhd71

New Member
Joined
Feb 15, 2021
Messages
11
Office Version
  1. 365
An xlsm file shouldn't open in compatibility mode, only old style xls should.
Yeah this is driving me crazy and my new IT people too. You want me to upload it and see if you can open it? It's only a 75kb file nothing crazy
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,974
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Did you see post number 4?
 

dhd71

New Member
Joined
Feb 15, 2021
Messages
11
Office Version
  1. 365
Did you see post number 4?
Sorry, I didn't see yours. No, this program was written by the owners son originally. Unfortunately I have not been able to get in contact with him for many years.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,405
Messages
5,624,574
Members
416,036
Latest member
eloisa manzanarez

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