rootdown42
Board Regular
- Joined
- Jun 8, 2005
- Messages
- 93
I have an excel file that is used to house our monthly sales data. The data comes from our database, which auto-generates multiple text files each week with updates sales information. I have created a template in excel that imports these text files into excel automatically using the Get External Data feature for importing text files. The External Data Range Properties is set to refresh the data when the file is opened each time to ensure that I am using the most current information.
The problem is that we now want to start storing versions of this monthly sales data for historical puposes, or in other words "freeze" the data for that particular sales month. This isn't a big deal since all I need to do is turn off the refresh option and then save the file so that the next time someone opens it, it won't import new sales data.
The pain is that I have over 20 worksheets and over 50 imported data sets that I need to change this refresh option on within this template. So my question is this: Does anyone know of a faster way to turn off this Get External Data refresh option for a whole workbook so that I won't have to do it manually each month?
The problem is that we now want to start storing versions of this monthly sales data for historical puposes, or in other words "freeze" the data for that particular sales month. This isn't a big deal since all I need to do is turn off the refresh option and then save the file so that the next time someone opens it, it won't import new sales data.
The pain is that I have over 20 worksheets and over 50 imported data sets that I need to change this refresh option on within this template. So my question is this: Does anyone know of a faster way to turn off this Get External Data refresh option for a whole workbook so that I won't have to do it manually each month?