Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I need to start an excel file on startup. However when opening the software always ask if the user wants to update the files. How can I get Excel to automatically do this every time?
Tools > Options > Calculations > Calculation > Automatic
Tools > Options > Calculations > Workbook options > Update remote references
Required, but never shown