szakharov7723
Board Regular
- Joined
- Jun 22, 2018
- Messages
- 85
- Office Version
- 2019
- Platform
- Windows
I am trying to figure out how to continuously pull data from multiple excel files, but not allow excel/query to change manually edited values back to source values
Example:
I have June, July, August files. I pull these files from folder
Sample data is
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64, align: right"]7/1/2019[/TD]
[TD="class: xl67, width: 64"] Zone#3[/TD]
[TD="class: xl68, width: 64, align: right"]6:00[/TD]
[TD="class: xl68, width: 64, align: right"]11:30[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]7/1/2019[/TD]
[TD="class: xl67"] Zone#1[/TD]
[TD="class: xl68, align: right"]7:00[/TD]
[TD="class: xl68, align: right"]5:30[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]8/1/2019[/TD]
[TD="class: xl67"] Zone#1[/TD]
[TD="class: xl68, align: right"]9:30[/TD]
[TD="class: xl68, align: right"]7:30[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]8/1/2019[/TD]
[TD="class: xl67"] Zone#3[/TD]
[TD="class: xl68, align: right"]1:00[/TD]
[TD="class: xl68, align: right"]4:30[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]6/1/2019[/TD]
[TD="class: xl67"] Zone#1[/TD]
[TD="class: xl68, align: right"]4:30[/TD]
[TD="class: xl68, align: right"]7:00[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]6/1/2019[/TD]
[TD="class: xl67"] Zone#2[/TD]
[TD="class: xl68, align: right"]5:30[/TD]
[TD="class: xl68, align: right"]9:30[/TD]
[/TR]
</tbody>[/TABLE]
As you see some times are reversed, hence any calculations going from there are wrong.
Thus I go ahead and correct these times. But after refresh these time are wrong again.
I know I could go to every source file, but it is really time consuming to do this, as there are many records in one months and there are many months as well.
So I am wondering if I can fixate manual changes in query file, so they do not get changed again
For instance, it could be not allowing any updates to current records or allowing only new files to be processed. Not sure what are capabilities of Excel query or potential work-arounds.
Example:
I have June, July, August files. I pull these files from folder
Sample data is
[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64, align: right"]7/1/2019[/TD]
[TD="class: xl67, width: 64"] Zone#3[/TD]
[TD="class: xl68, width: 64, align: right"]6:00[/TD]
[TD="class: xl68, width: 64, align: right"]11:30[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]7/1/2019[/TD]
[TD="class: xl67"] Zone#1[/TD]
[TD="class: xl68, align: right"]7:00[/TD]
[TD="class: xl68, align: right"]5:30[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]8/1/2019[/TD]
[TD="class: xl67"] Zone#1[/TD]
[TD="class: xl68, align: right"]9:30[/TD]
[TD="class: xl68, align: right"]7:30[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]8/1/2019[/TD]
[TD="class: xl67"] Zone#3[/TD]
[TD="class: xl68, align: right"]1:00[/TD]
[TD="class: xl68, align: right"]4:30[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]6/1/2019[/TD]
[TD="class: xl67"] Zone#1[/TD]
[TD="class: xl68, align: right"]4:30[/TD]
[TD="class: xl68, align: right"]7:00[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]6/1/2019[/TD]
[TD="class: xl67"] Zone#2[/TD]
[TD="class: xl68, align: right"]5:30[/TD]
[TD="class: xl68, align: right"]9:30[/TD]
[/TR]
</tbody>[/TABLE]
As you see some times are reversed, hence any calculations going from there are wrong.
Thus I go ahead and correct these times. But after refresh these time are wrong again.
I know I could go to every source file, but it is really time consuming to do this, as there are many records in one months and there are many months as well.
So I am wondering if I can fixate manual changes in query file, so they do not get changed again
For instance, it could be not allowing any updates to current records or allowing only new files to be processed. Not sure what are capabilities of Excel query or potential work-arounds.