Page 1 of 1

Robotask won't read cells in excel when running third party functions

Posted: Sun Feb 19, 2023 8:26 pm
by johnax01
I have a spreadsheet that runs functions from a third party called MarketXLS. The functions read in data on stocks etc. When I try to run a Robotask macro that opens and reads the spreadsheet, the data that is supposed to be called in by the MarketXLS functions doesn't seem to update. so Rabotask cannot read it. Why doesn't the data update in excel using the third party functions from MarketXLS when robotask opens the spreadsheet?

Re: Robotask won't read cells in excel when running third party functions

Posted: Tue Feb 21, 2023 5:14 pm
by Rukbunker
Just to eliminate: does Robotask reads the Excel file when you have disabled that add-in?

Re: Robotask won't read cells in excel when running third party functions

Posted: Tue Feb 21, 2023 8:50 pm
by johnax01
Robotask will read a cell in the spreadsheet that just has a number in it even with the MarketXLS add in enabled. But Robotask won't read a cell that uses a function from MarketXLS in that same spreadsheet. Somehow it seems that Robotask is disabling the function and so it reads the cell as an error.