ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Preserve existing data whilw using external links (https://www.excelbanter.com/excel-worksheet-functions/82044-preserve-existing-data-whilw-using-external-links.html)

Hal

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.


All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com