Excel Data Query stops at specific date

willow1985

Well-known Member
Joined
Jul 24, 2019
Messages
635
Office Version
  1. 2019
Platform
  1. Windows
I am not sure if anyone can answer this but I thought I would give it a shot.

I have no experience with data Queries. My IT department set up a data query to get a live feed of data from our ERP system. It would automatically refresh every time the excel book was opened with up to date data. IT did an update to the system but swears it should not have affected the Query, however it stopped automatically refreshing to the current date and stops at a specific date of Aug 20. This happens accross 5 excel spreadsheets and 5 different Queries.

IT claims it is excel thats the problem. Any idea what could cause this?
What information would you need from me to troubleshoot?

Thank you to anyone who could point me in the right direction or even help me explain it to my IT department.
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,132
I didn't verifying that , to do that I should be there and check on live data :)
But everything you posted looks correct
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

willow1985

Well-known Member
Joined
Jul 24, 2019
Messages
635
Office Version
  1. 2019
Platform
  1. Windows
Thank you. Then I am puzzled to why it is not working but I will keep nudging IT. Thanks again
 

willow1985

Well-known Member
Joined
Jul 24, 2019
Messages
635
Office Version
  1. 2019
Platform
  1. Windows
Was solved. IT changed the server name so I was referencing the wrong name. Thank you guys for verifying the query code though!

You guys are awesome!!
 

Watch MrExcel Video

Forum statistics

Threads
1,114,663
Messages
5,549,290
Members
410,908
Latest member
Allen P
Top