Share via

VBScript fails at "refreshall" statement for excel having power query when size of excel outputis around 50 MB

Anuj Bansal 1 Reputation point
2021-03-03T06:06:14.277+00:00

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.
Community Center | Not monitored

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.