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