Separate names with a comma.
Discussion in 'Troubleshooting' started by ed b, Nov 2, 2017.
i have 800 rows in my spreadsheet with 3 functions. a refresh is taking over 15 minutes.
Please can you try out the latest version, it has some better caching. May I ask which functions do you have in the sheet?
i load the new version, performance is still bad, i am using last, open and prior close.
ok, may I ask how many symbols roughly?
We are putting this on a bigger box. You will see improvements soon.
in the meantime, what is the vba code to execute your ribbon command to refresh selected. Open and previous close are only needed once a day. i have coded a select 100 cells loop to select and refresh only last trade.