Excel 2016 creating a new workbook using VBA gives error for some users on some computers

Hi guys,

We have a problem thats had all the devs in our office scratching our heads. This is particular to office 16/ windows 10 and can only be replicated with certain combinations of excel files, computers and users.

The issue is that for some users on some machines when running a report they are getting:
"Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook."

The same user on different machine works.

A different user on the same machine works.

Here is the relevent code:

Dim wbTemplate As Excel.Workbook, wbData As Excel.Workbook, wsData As Excel.Worksheet

Set wbTemplate = Application.ActiveWorkbook

Set wbData = Application.Workbooks.Add

Application.DisplayAlerts = False
wbTemplate.Sheets(Array("Summary", "Detail")).Copy before:=wbData.Sheets(1)

The error throws on the last line of code above. Any ideas?

Thanks very much

~TheShoe

Thanks very much!

That worked perfectly.

You are one excellent dude.

Thanks xInitwit

It looks like the issue was something to do with the office install or perhaps some group policy. https://support.office.com/en-us/art...7-23ff5f381fb5

On a working pc the option ‘Excel Workbook (*.xlsx)’ is selected however on the not working system its not got that option, it only has ‘Excel Workbook’ missing the file extension inside the brackets.