LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hal
 
Posts: n/a
Default Preserve existing data whilw using external links

I have a workbook that contains links to external data sources and, upon
opening the file I am given a startup prompt with an option that says "if I
don't update the links, Excel will use the previous informtion" and, when I
choose this option it then tries to update and producing errors because the
external data is not available. I want to work with the existing data. How
do I preserve the existing data? This feature works fine in 2000 but not in
2003. Any thoughts?
--
Now if only I could get the pod door open.
 
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
How do i refresh external data import in excel in seconds Bala New Users to Excel 2 December 29th 05 05:12 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
Help - external data Excel Discussion (Misc queries) 0 April 11th 05 08:52 PM
Using "Get External Data" gifer Excel Worksheet Functions 2 March 11th 05 05:53 PM
Data Table - Does it work with DDE links and stock tickers? Post Tenebras Lux Excel Discussion (Misc queries) 0 December 1st 04 05:15 PM


All times are GMT +1. The time now is 07:22 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"