Power query not updating

rich987652

New Member
Joined
May 14, 2002
Messages
29
Hi - I have a problem with power query not updating all data from my source file.

My query was created from file / from folder, and I currently only have a single file in that folder at the minute. I have imported that data into power query with no issues currently, however if I change some data in the original file (in some of the columns) and re-save the file and refresh the query then power query is not reflecting those updates.

The columns that are not being updated have a percentage format not sure if that is causing an issue. The only reason I say that is if I change some other columns with a whole number format, then they are getting updated in power query.

I've search around for anyone having similar issues but can't find any.

Richard
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Hard to say something without any example which reflect your problem
maybe check status of source data type in this column and in the query table
 
Upvote 0
you can :)
post a links to shared Excel files using GoogleDrive, OneDrive or any similar
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

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