Excel 2013 repairing macro enabled file HELP

sibley14

New Member
Joined
Jun 4, 2014
Messages
38
Hi,

I hope someone can help.

I have a macro enable sheet which allows me to tick off order numbers as i go. Each number highlights green with red text so that i can see visually alongside the tick which numbers have been used.

This was working fine on Excel 2007, but i started having massive problems with windows 10 latest update so decided to upgrade my excel (After microsoft told me it was incompatible)

When i open the sheet now, excel gives me a message to say that it contains unreadable content, it then proceeds to 'repair' the sheet and re-opens it. However the sheet then becomes damaged. This is causing an issue as others also use this sheet shared via googledrive.

Does anyone know how to prevent excel from auto-repairing the sheet?

Here's the information i am getting

(Opening the sheet) Excel found unreadable content do you want to recover the contents? (Click yes)

(Then pop up message) Excel was able to open the file by repairing or removing the unreadable content:

Removed Records: Object from /xl/printerSettings/printerSettings1.bin part (Print options)

<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error091680_02.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\----\Google Drive\Order Sheets Macro.xlsm'</summary>
-<removedRecords summary="Following is a list of removed records:">
<removedRecord>Removed Records: Object from /xl/printerSettings/printerSettings1.bin part (Print options)</removedRecord>
</removedRecords>
</recoveryLog>

If anyone has any advice on how to fix this it would be much appreciated.

Thanks
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Forum statistics

Threads
1,214,944
Messages
6,122,391
Members
449,080
Latest member
Armadillos

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