I created a few charts using Qlik Sense Desktop and data from Excel spreadsheets. The data is updated weekly. How can I refresh the data used for my charts with the new data from the spreadsheets?
IN desktop you need to reload the data manually on demand. If you have a scheduling/automated distribution requirement then you need to look at the server edition.
Data Load Editor/Load Data
Batch file is an option for updation in Desktop, check this:
Qlik Sense execute batch
How to reload from Batch file Qlik Sence
You will be needing Qlik Sense server to schedule reloads. On a desktop version you need to do it explicitly.
Retrieving data ...