View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RobC RobC is offline
external usenet poster
 
Posts: 15
Default 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?