Hello everyone,
I have an issue with an excel resource;
what happens is that I add an excel file with Auto Calculate to the resources, but, when I download the excel file from a screen the Auto Calculate gets lost and I need to manually re-calculate the results.
Got any suggestion to fix this issue?
Thanks for your time and support
Hello Gianmaria bellucci,
Are you aware of this component?
Best regards,
Ana
Hi Gianmaria,
Can you check of the excel in the resources have the Auto-Calculate option enable? Maybe the version that is there is with that option disable.
To verify that, go to the File tab appearing at the top-left corner in your Excel file. Then, head to the Options. Select the Formulas tab on the left panel. Now, here check if the calculation mode is set to Automatic or Manual.
Hope this can help you.
Ricardo
Hello Ana, Hello Ricardo, really sorry for kept you waiting; both your solutions combined where correct,
thank you so much.
Have a nice day,
Gianmaria