Hey. All of this, combined, worked to solve the problem.

1) Share the workbook.

2) Ensure that the workbook is in a place for which the security is right to allow access from Visual Studio and also the SSRS Service account that you deploy to.

I've just started another excel project and got caught out by not sharing the workbook!