I am running a VB script which involves:
- Creation of folders
- Opening of Excel with power queries
- refreshing the excels to run the power queries
- saving the excels
When I am running this query on the remote server having 32 bit Office 2016 and 64 bit OS:
- it runs fine for scenario when size of output excel is ~10-20 MB
- but fails at "refreshall" statement when size of output excel is 50 MB
However in my local system with 64 bit office and 64 bit OS this query runs fine for all scenarios irrespective of output excel file size.
Is it happening due to 32 bit office or is there any other reason behind it? Please provide a solution.