Build Error + Creating VSTO addin for excel 2010

Question

I try to create an excel add-in using VS 2010. When I create a new project Excel 2010 Addin, and try to compile the solution. I get an error which says.

'Error  1   The "FindRibbons" task could not be loaded from the assembly            
'Microsoft.VisualStudio.Tools.Office.BuildTasks, 
'Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a.  Confirm that the   
'<UsingTask> declaration is correct, that the assembly and all its dependencies are   
'available, and that the task contains a public class that implements   
'Microsoft.Build.Framework.ITask.   DemoExcelAddIn1

I downloaded an installed the VS 2010 tools for office runtime. But I cannot locate the assembly 'Microsoft.VisualStudio.Tools.Office.BuildTasks,

How do I proceed. Could anyone help..

I found no ways on obtaining the missing assembly. I upgraded to Visual Studio 2012 and the error disappeared. Could anyone help me on fixing the issue with Vs 2010 — Sandepku, May 04 '13 at 17:36

score 9 · Accepted Answer · edited Jun 20 '20 at 09:12

9

This looks like a known issue sourced from MSDN forums - you just need to update your Microsoft.VisualStudio.Tools.Office.targets file to point to version 11.0.0.0 instead of version 10.0.0.0.

Updating MSBuild Targets File

For those who encounter this problem, go to C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v10.0\OfficeTools and open the Microsoft.VisualStudio.Tools.Office.targets file.

Replace all 10.0.0.0 with 11.0.0.0.

edited Jun 20 '20 at 09:12

Community

1
1

answered May 06 '13 at 14:18

SliverNinja - MSFT

31,051
11
110
173

Edit Microsoft.VisualStudio.Tools.Office.targets file and replace Replace all 10.0.0.0 with 11.0.0.0 but got same error – Shyam sundar shah Mar 29 '14 at 13:21
3

@Shyamsundarshah Judging by the date of your comment you probably have VS2013 installed. You need to replace `10.0.0.0` with `12.0.0.0`. – The Muffin Man Sep 16 '14 at 20:09
@SliverNinja, after making the change, I got the new error: – user3601704 Jun 15 '15 at 21:33
please see : http://stackoverflow.com/questions/30855404/a-new-build-error-after-making-change-by-replacing-version-10-0-0-0-with-11-0-0 – user3601704 Jun 15 '15 at 21:50

score 0 · Answer 2 · answered Jul 28 '15 at 13:32

0

Install VS2010 SP1, that should resolve your problem.

I had this problem as well, i then installed VS2010 SP1 & VS2013 SP4.

Cheers !

answered Jul 28 '15 at 13:32

Telson Alva

842
6
22
37

score 0 · Answer 3 · answered Dec 07 '15 at 20:37

We have VS2013 installed on the build slaves, so we fixed the issue by doing the following: go to C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\OfficeTools and open theMicrosoft.VisualStudio.Tools.Office.targets file.

Replace all 11.0.0.0 with 12.0.0.0.

Build Error + Creating VSTO addin for excel 2010

3 Answers3

Updating MSBuild Targets File

Linked