LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refreshing Data from a web query smith_gw Excel Discussion (Misc queries) 0 April 25th 07 10:44 PM
Simple MS Query with Data Parameters Not Auto-refreshing [email protected] Excel Discussion (Misc queries) 0 March 14th 07 03:00 PM
How can I stop charts from refreshing when changing source data? Jens Rauff Charts and Charting in Excel 0 June 22nd 06 08:30 AM
problem refreshing data query on yahoos jcoudrie0734 Excel Discussion (Misc queries) 0 October 4th 05 12:14 AM
Query to external data not refreshing R Ormerod Excel Discussion (Misc queries) 1 April 1st 05 08:39 PM


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"