Is it possible to avoid refreshing of present data in Excel Query ?

szakharov7723

Board Regular
Joined
Jun 22, 2018
Messages
85
Office Version
  1. 2019
Platform
  1. 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.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,223,708
Messages
6,174,006
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top