New Tab Creation Naming Configuration

Hi All,

I recently created a VBA in HP's ALM to perform an extract of data from the requirements module into an Excel spreadsheet. This VBA also creates a Pivot Table in the newly created Excel spreadsheet. Basically what it does is the following:

(1) Create a single worksheet workbook where the worksheet name is "Query1"

(2) Create a Pivot Table from "Query1" in a new worksheet (in the same workbook) with the name "Sheet2"

I've created this using Excel 2016. I had a colleague test this out and, the result of the VBA line "Sheets.Add" results in "Sheet30" being created, as opposed to "Sheet2". This is done on a brand new workbook, so it is not like tabs were created then deleted.
I should also state that my colleague is using Excel 2010.
Any thoughts as to how I could correct this for my colleague? Does my colleague need to have configuration changes (Options) in their Excel 2010 environment?

Thanks,
Nick