Asus computer corrupts xlsm file?

Lil2606

Board Regular
Joined
Jan 29, 2019
Messages
76
Hi all,

I have a 1 year old Asus laptop (gamer, so pretty high specs) a 3 year old MSI PC (also gamer, practically a mini nuclear power plant) and a 6 year old Lenovo (which barely lives and even 6 years ago was very poor specs.. I used it to take it to school to make notes, and thats about its ability..) all with win10 and I have MSOffice license from school, which I can use on 5 computers, so I have the exact same office, exact same license on all 3 computers.

I started to work on a project, an xlsm file, which I started to work with, on the Asus, then I got my PC back so I put it over to the MSI and carried on working on it, only to find out that when I copied it back over to the Asus, to take it to he office with me, the xlsm froze on Sheet1 (All other sheets are fine until I don't click on Sheet1, and Sheet1 is the only one without any macros on it), then crashed completely. I assumed the file just got corrupted and I have to go back to a previous version, but when I copied it back onto the MSI, it worked again like a charm.. out of curiousity I tried it on a company DELL, works like a charm.. then tried it on my dying Lenovo, and I had absolutely no issues with it.

Anyone had any similar phenomenom? Has any clue about why this would happen?

Please let me know! Cheers!

Question posted on ExcelForum as well. Link:
https://www.excelforum.com/excel-programming-vba-macros/1274088-asus-computer-corrupts-xlsm-file.html#post5110487
 

Macropod

Retired Moderator
Joined
Aug 27, 2007
Messages
3,312
Have you tried repairing the Office installation (via Windows Control Panel > Programs > Programs & Features > Microsoft Office (version) > Change > Repair)?
 

Lil2606

Board Regular
Joined
Jan 29, 2019
Messages
76
Yes I tried but it didn't work.. so I uninstalled it completely then reinstalled it and the issue is still present
 

Macropod

Retired Moderator
Joined
Aug 27, 2007
Messages
3,312
In that case, you might try running the System File Checker and a full AV scan.
 

Lil2606

Board Regular
Joined
Jan 29, 2019
Messages
76
Thanks for that, I just did the SFC it did find corrupted files, but said it repaired them (also had updates on office), but the file still crashes.. :/
 

Forum statistics

Threads
1,081,933
Messages
5,362,235
Members
400,672
Latest member
ExcelGrasshopper

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top