How to force a spreadsheet to re-calculate using the Windows Task Scheduler

[Window123]

Windows 10. Microsoft 365 version 16.0.16130.20306
The spreadsheet in question keeps track of my medical prescriptions, so it's important that it is accurate. It needs to re-calculate daily even though no changes have been made. Simply remembering is unreliable.
A previous version of the spreadsheet used VBA code, but that spreadsheet no longer works because it uses a custom replacement published by Chip Pearson. My VBA skills are not at a level that I can modify that code. BTW, Pearson freely offered that code for any one to use and modify.

Thanks fir your help.
Window123

 

[James006]

Hi,
Take a look at this step-by-step explanation for Windows Task Scheduler

How To Automatically Run Excel VBA Macros Daily

Learn how to utilize a few programs you already have to create automation rules that will automatically open up your Excel files, run VBA code, save the changes, and then close the file. These automations can even be setup to run while you sleep!

www.thespreadsheetguru.com

 

[Herakles]

Does it actually only need to recalculate when you open the workbook or activate a worksheet or even just select a cell?

All of this can be achieved using a workbook or worksheet event.

We can help you with that.

 

[Window123]

Herakles, Thanks for your reply.
Does it actually only need to recalculate when you open the workbook or activate a worksheet or even just select a cell?
Yes, it does. I had pretty much accepted that I'd need to use the VBA solution suggested by another user.
I take it that All of this can be achieved using a workbook or worksheet event means that your solution doesn't require VBA? If so, I'd prefer yours.
I don't know what a "mini-sheet" is, but perhaps it would help if I uploaded one?

Window123