Stop automatic data reformat when refreshing a query

R

RobC

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing some Pivot Tables makes Excel stop or crash 0
Refreshing some Pivots Tables makes Excel stop or crash 0
Stop Refreshing via VBA 3
Adding Data and Refreshing Data 1
retain custom date format "text" when pasting or reformatting data 2
Indexing for data found within a Table Query 2
Problem importing external data / Automatic publishing webpage 0
Refreshing Data from a web query 0

Top