Some Cells After MS Query Table Refreshed Have to Be Clicked before Formatting Works

[elwayfan446]

Hello all.

I have a situation that is driving me crazy. First off, I am using excel in Office 365.

I have a workbook in which I export data out of SAS tables into different sheets. I have a main sheet where I use MS Queries to pull that data in from the other worksheets in the workbook. I have formatted certain columns in each of them to be percentages and currency. 3 of the 4 queries keep that formatting when the workbook is refreshed, however, 1 of them is not refreshing correctly. When refreshed, the data populates in a way that I have to double click on the cell and move out of it for the format to take effect. It's only happening in a couple of columns in the query.

I have tried the following:

• Made sure all the options for preserving the formatting have been checked
• Deleted the query and recreated it
• Created the same query in different worksheets to see if there was some issue with the specific cells that I was having to click on. Happens no matter where I put it

I have put an all out blitz on Google but can't find an answer that fixed my problem. I just can't figure out why 3 of my queries work fine but this one doesn't. All data that feeds in from the other tabs are formatted identically (general) on the tabs.

I am hoping someone can help asap.

Thanks!

 

[elwayfan446]

Anyone that can take a crack at this for me?

 

[elwayfan446]

Well, I ended up rebuilding it all in Power Query vs. MS Query and everything seems to be working better.