ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Not able to disable external links please help (https://www.excelbanter.com/excel-discussion-misc-queries/84193-not-able-disable-external-links-please-help.html)

Amit Sharma

Not able to disable external links please help
 
Hi While i open a external linked file in exel 2003 it's not alow me to
disable this option, where as it is asking me to update or don't update the
same but external linked cell showing N/A. What should i do

Dave Peterson

Not able to disable external links please help
 
xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Amit Sharma wrote:

Hi While i open a external linked file in exel 2003 it's not alow me to
disable this option, where as it is asking me to update or don't update the
same but external linked cell showing N/A. What should i do


--

Dave Peterson


All times are GMT +1. The time now is 03:02 PM.

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