As, when I am copying each worksheet to a new spreadsheet using addFromSpreadsheet() method and then changing the name of each worksheet from 'Copy of sheet_abc' to 'sheet_abc'. But after this, some cells are showing reference error as shown below:-
It seems like while copying, orders of worksheet matters. I have also tried to refresh this spreadsheet. But error does not get resolved.
As, when I am copying each worksheet to a new spreadsheet using addFromSpreadsheet() method and then changing the name of each worksheet from 'Copy of sheet_abc' to 'sheet_abc'. But after this, some cells are showing reference error as shown below:-
It seems like while copying, orders of worksheet matters. I have also tried to refresh this spreadsheet. But error does not get resolved.