Is there a difference between Excel Office 365 and Excel 2013 ? -2147417848(80010108) Error

[Devonair]

Hi Everyone,

I installed Excel 2013 on my PC. and made the excel workbook with VBA in it. It is now perfectly running.
When I went for work and used my newly made excel workbook. it started having many problems in our office we use Excel Office 365.

the Error I am having is
===================
Run-time error '-2147417848(80010108)':

Method 'Range' of object '_Worksheet' failed
===================

clicking Debug mode I went to this line that looks fine to me.

=============================================
Private Sub Worksheet_Change(ByVal Target As Range)

If Sheets("ARCHIVE").Range("A12") = 1 And Sheets("DATABASE").Range("B3") <> "" Then
Sheets("ARCHIVE").Range("A12").Value = 0
Call Eraser2
Call RowCount2
Call Window2
Call Mark2
End If

End sub
=============================================

So, I experimented on the case, I totally removed the if endif commands. Now it made a domino effect, the other codes are having error as well.

=============================================

Private Sub Worksheet_Change(ByVal Target As Range)​

Sheets("ARCHIVE").Range("A12").Value = 0​

Call Eraser2
Call RowCount2
Call Window2
Call Mark2
End If

End sub​

=============================================

Deleting this error...

This error popped up next
=============================================

Sub Eraser2()
Sheets("Report 02").Range("A5:A100").Clear
End Sub
=============================================

Deleting this error the Workbook run infinitely and hang.
all cells went big.



Can anybody explain what is happening ?


Thanks again guys.

 

[Macropod]

Your description suggests either that the workbook is corrupt or, more likely, that the Office 365 installation is faulty. Try repairing the Office 365 installation.

 

[Devonair]

Your description suggests either that the workbook is corrupt or, more likely, that the Office 365 installation is faulty. Try repairing the Office 365 installation.

Thank you for your quick reply

I will ask our IT team here to have my Excel reinstalled, thanks again.

 

[Macropod]

Reinstalling is typically overkill, which is why I suggested a repair. See: https://support.office.com/en-US/Ar...lication-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

 

[Devonair]

You're suggestion worked they installed a new copy then it went OK... till something odd again happen in my next post.