Is it possible to auto recalculate when open .xlsx files
ex. opening time is 09-Oct-19 12:38:00 I want to see value at 09-Oct-19 12:38:00 when opened it.
Request you to check below KB article to automating the same when windows opens :https://customers.osisoft.com/s/knowledgearticle?knowledgeArticleUrl=KB01035
Actually, I wanna know can I do it without coding? Because some files can auto recalculate when open. But some can't.
Check these options please. Maybe help you.
CTRL + ALT + SHIFT + F9 to recheck all formula dependencies and then recalculate all formulas.
Retrieving data ...