I have a xlsx workbook that uses other xlsx workbooks's values in its formulas to generate cell values (these other workbooks need to be open to get the final workbooks values in Windows). E.g. final.xlsx needs original1.xlsx-orignal10.xlsx open to generate its values.
Is there a way in Ubuntu/Linux to: (1) Open all workbooks to get the final workbook values, and then (2) copy paste the final workbook's contents as values/text so the original workbooks dont need to be opened to get the final workbooks values? I was thinking of using Python Openpyxl to open all workbooks and generate final.xlsx and then copy paste as values into another workbook, but opening the original xlsx files doesnt populate final.xlsx.
Thanks