ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Stop automatic data reformat when refreshing a query (https://www.excelbanter.com/excel-discussion-misc-queries/195978-stop-automatic-data-reformat-when-refreshing-query.html)

RobC

Stop automatic data reformat when refreshing a query
 
My data suddenly started auto-reformatting to dates when I refreshed my
queries. I can manually change them back and choose to "preserve formatting"
but then I lose my hyperlinks that are included in the query.
I have verified that the source data has not changed to date format.

How do I stop the data conversion upon refresh?


All times are GMT +1. The time now is 04:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com