Hot answers tagged excel
Adding references implies early binding. But early binding is not necessary to use any component registered in the COM registry. You can just use the CreateObject function to get back a late-bound reference to the object. It's not pretty, but it works. You just need to know the fully qualified name of the object. I'm assuming that here it's ...
Our shop uses ALM 11.00 (new version of QC) but on the add-in page it specifically says the following Excel versions are supported: Versions supported: Microsoft Excel 2007 and 2010 (32 bit) with HP ALM 11.00. I would uninstall office 2010 and restall it as a 32 bit version. THe 32 bit version works on a 64 bit machine and I'm able to use the excel plugin ...
couple of points/questions 1) what number of defects are we talking about ? If it's UAT and you are getting too many defects to enter manually then maybe you have other problems ? :) 2) Maintaining the defects in QC means there is a history behind them, doing it in Excel loses that. So maybe you gain from ease of use by using Excel but you could lose out ...
The dates for the burn down chart in excel for the Agile and CMMI templates are set by the date filters on the chart, you need to right click on the date column in the pivot table and then select the dates you want. For the new agile template, these dates are probably sourced from the start and finish dates on the sprint work item template.
Only top voted, non community-wiki answers of a minimum length are eligible