LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Distella
 
Posts: n/a
Default Excel will not automatically refresh external data on open

I have created a data source using Microsoft text driver and it works fine on
manual refresh. However, I cannot get it to refresh data automatically on
opening the workbook. I have checked 'Refresh data file on open' in External
Data Range Properties and 'Save query definition' is also checked. Is there
something I'm missing? Any advice would be much appreciated. Thanks.
 
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
Refresh data from an Excel sheet Sierras Excel Worksheet Functions 1 February 24th 06 08:44 PM
When I open Excel, workbooks open automatically. How can I stop t Rhealbird Excel Discussion (Misc queries) 2 February 23rd 06 10:08 AM
How can I have the Import External Data dialog pop up on open? Benny Setting up and Configuration of Excel 1 November 19th 05 10:13 AM
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 Rich Rodberg Links and Linking in Excel 1 October 21st 05 07:53 AM
External Data Refresh is extermely slow after upgrading to 2003 Simon Excel Discussion (Misc queries) 0 September 28th 05 02:02 PM


All times are GMT +1. The time now is 03:09 AM.

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"