https://community.qlik.com/t5/QlikView/Reading-excel-sheet-with-external-references/m-p/1896068#M1217540 <P>Excel may - depending from the user- and document-settings - update external references and calculating the application. But if another tool like Qlik access the Excel nothing of the above will happens else the stored data will be read. I doubt that you could change anything on this behaviour. Thinkable are any kinds of macros and batches which update all related Excel files but maybe a change within your process-logic might be easier, for example loading the data from all relevant Excel and doing the calculations within Qlik.</P> <P>- Marcus</P> Tue, 22 Feb 2022 15:58:12 GMT marcus_sommer 2022-02-22T15:58:12Z https://community.qlik.com/t5/QlikView/Reading-excel-sheet-with-external-references/m-p/1896014#M1217537 <P>Hello,</P> <P>I have an excel sheet with a single row and 5 columns. Each cell references a value in another spreadsheet. These values can change daily.</P> <P>When I do the first reload - Qlikview gets the data from the spreadsheet. Now if the data changes in the referenced spreadsheets and I do another reload&nbsp;(next day) - Qlikview does not load the latest data. I have a feeling it checks the timestamps of the excel file and sees that no change have been made, therefore it doesn't reload the latest data.</P> <P>I have to go into the spreadsheet, click a cell and then save. Only then when I reload the latest values are available.</P> <P>&nbsp;</P> <P>Does anyone have any advice regarding this?</P> <P>&nbsp;</P> <P>Thanks</P> Tue, 22 Feb 2022 14:54:52 GMT https://community.qlik.com/t5/QlikView/Reading-excel-sheet-with-external-references/m-p/1896014#M1217537 QlikMo 2022-02-22T14:54:52Z https://community.qlik.com/t5/QlikView/Reading-excel-sheet-with-external-references/m-p/1896068#M1217540 <P>Excel may - depending from the user- and document-settings - update external references and calculating the application. But if another tool like Qlik access the Excel nothing of the above will happens else the stored data will be read. I doubt that you could change anything on this behaviour. Thinkable are any kinds of macros and batches which update all related Excel files but maybe a change within your process-logic might be easier, for example loading the data from all relevant Excel and doing the calculations within Qlik.</P> <P>- Marcus</P> Tue, 22 Feb 2022 15:58:12 GMT https://community.qlik.com/t5/QlikView/Reading-excel-sheet-with-external-references/m-p/1896068#M1217540 marcus_sommer 2022-02-22T15:58:12Z