Formatting of Columns is Not Retain when I Refresh Query

Posted by admin | Apr 2, 2020 | All, Microsoft | 0 |

I tried to reply on this thread but it is locked:
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2016/formatting-of-columns-is-not-retain-when-i-refresh/5dc6f34e-fe76-4f22-ba55-119da59f836c

You basically need to Check OR UNcheck the following:

Preserve column sort/filter/layout
Adjust column width
Preserve cell formatting

These settings are in relation to the Data on the connector meaning it will preserver that back end formatting. Hope that makes sense and helps someone.

About The Author

admin

Categories

Recent Posts

Power Automate Using SharePoint Actions instead of OneDrive Actions April 11, 2023
Using Power Automate to Populate a Word Template April 4, 2023
Dynamics CRM 365 get and set values for different data types with Java Script March 14, 2023
Power Automate Archive Folder from One Document Library to Another March 9, 2023
How to read Electronic Schematics January 25, 2023