Hi

can someone help me with this setting in excel? I want the excel users to never overwrite the data as it is connected to the database. every time they open the excel, the data will refresh. I am not sure if I should check this box or not.

Remove data from the external data range before saving the workbook Select this check box if you want to save the workbook with the query definition but without the external data. Clear this check box to save the query definition and data with the workbook. This check box becomes available only after you select the Refresh data when opening the file check box