I have following function

function copyValues(range) {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange(range).copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
}

Majority of the times, it is working fine, but sometimes it is pasting a value Loading...

It may be related to some custom/named function I have, which is listed below.

USD2INR=Summary!$K$8*usd_amount

The cell Summary K8 has following value.

=GOOGLEFINANCE("CURRENCY:USDINR")*0.995*1

Few cells also have values like =-GOOGLEFINANCE("VOOG") * 2.983

My guess is that it is because of this google finance functions that are trying to get values and this is what is causing this issue during copy paste function getting executed. Can anyone suggest what I can do to fix this issue.