File containing macros will not open on new computer

chadski778

Active Member
Joined
Mar 14, 2010
Messages
297
Hi,
My colleague has recently received a new laptop but now he can't open a macro containing file that previously he was able to open with his old computer. The error message is '"Unreadable content from Excel was found in "GLOSS Macro (v 1.3 or later). Do you want to restore the contents of the workbook? If you trust the source of this workbook, click Yes."
When he clicks "Yes" he gets the following error message, “
He has macros enabled and he is using the same version of Excel as me which is Windows Office Professional Plus 2010 Excel version 14.0.7173.5000 (32 bit). Any ideas why this is happening?
Log data
<?xml version=”1.0” encoding=”UTF-8” standalone=”true”?>
<recoveryLog xmlns=http://schemas.openxmlformats.org/spreadsheetml/2006/main>
<logFileName>error062720_01.xml</logFileName>
<summary>error in file ‘C:\Users\Name of person\Desktop\GLOSS\Filename.xlsm’</summary>
<removedRecords summary=”following data sets were removed:”>
<removedRecord>Removed record: Designated area /xl/workbook.xml-Part (Workbook)</removeRecord>
</removedRecords>
</recoveryLog>


Thanks
Chad
 

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.
The log data report hasn't copied fully. Here it is:
<?xml version=”1.0” encoding=”UTF-8” standalone=”true”?>
<recoveryLog xmlns=http://schemas.openxmlformats.org/spreadsheetml/2006/main>
<logFileName>error062720_01.xml</logFileName>
<summary>error in file ‘C:\Users\Name of person\Desktop\GLOSS\Filename.xlsm’</summary>
<removedRecords summary=”following data sets were removed:”>
<removedRecord>Removed record: Designated area /xl/workbook.xml-Part (Workbook)</removeRecord>
</removedRecords>
</recoveryLog>
 
Upvote 0

Forum statistics

Threads
1,214,411
Messages
6,119,360
Members
448,888
Latest member
Arle8907

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
Back
Top