Google Sheet #ERROR! Exceeded maximum execution time line 0

[mattiaotto]

Hello, from this morning the MuFunds formula do not work anymore with the error, #ERROR! Exceeded maximum execution time line 0, is it something that can be fixed?

Thanks,
Mattia

[joseballester]

Hi Mattia! This is not a muFunds' error itself, but Google Sheets complaining because the function is taking too much time.

I suspect this could be because:

(a) Many function calls are being performed at the same time (e.g. when you open a spreadsheet with many cells using muFunds). In that case, I would suggest reducing the number of cells using the function or calling muFunds asynchronously, with a time-based trigger. I'm planning to make this easier in the future, because many users find this problem, but in the meanwhile you could find some inspiration here.

(b) Morningstar is responding slowly in that moment. In that case, I would suggest trying again later.

[mattiaotto]

thank you!

…

On Mon, 25 Nov 2024 at 14:05, Jose Ballester ***@***.***> wrote: Hi Mattia! This is not a muFunds' error itself, but Google Sheets complaining because the function is taking too much time. I suspect this could be because: (a) Many function calls are being performed at the same time (e.g. when you open a spreadsheet with many cells using muFunds). In that case, I would suggest reducing the number of cells using the function or calling muFunds asynchronously, with a time-based trigger. I'm planning to make this easier in the future, because many users find this problem, but in the meanwhile you could find some inspiration here <https://mufunds.com/history.html>. (b) Morningstar is responding slowly in that moment. In that case, I would suggest trying again later. — Reply to this email directly, view it on GitHub <#66 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BNEP75KUHI6J76B3PULADTD2CMVDHAVCNFSM6AAAAABSI2UY72VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIOJYGEYTEOBQGQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>