C# system.runtime.interopservices.comexception: 'the RPC server is unavailable.

See more:

C#

.NET

Visual-Studio

Almost everything I have read says the firewall causes this problem. I am running Avast and turned it off in its dialogue box. I still get the error. I have been fighting with this for two days now; I am at my wit's end. I am going bald from pulling my hair out.

It happens when this line of code is executed.

chart.SeriesCollection(3).XValues = @"=Totals!$B$3:$B" + newRow;

Where a new row is a new row inserted and $B:$B is a list of dates.

Please help

What I have tried:

Turning the firewall off
Changing the order of the code
Removing the delete series code.
Tried running the .exe file, and the debugger and received the same results