#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default External Link Issue

I have come across something rather bizarre that I hope someone can
answer.

I opened a workbook in excel, we will call it Book1, that has
external
links, I opt to "Don't Update". In the workbook are links to
someone's
C: drive and as far as I am aware I don't have access to their drive.
Also FYI ... The status bar in the lower right says "Ready" ... not
"Calculate". Plus, if I hit "F9" the numbers remain the same. When I
look at a cell "D10" it shows $90.


Then I open a copy of the same file but named Book2 .... Book1 is
still open. I again click "Don't Update" and the status bar says
"Ready". I click "F9" just to check that it is calculated. However,
in
this book "D10" shows $100.


Now this is where it gets wierd. If I go back to Book1, cell "D10"
now
says $100, it changed and book Book2 still says $100.


Why would this be happening? It seems that the book is some how
updating despite that fact I am saying "don't Update". If I open the
books reversed, Book2 and
Book1 the cells now both say $90. It seems that the last book to open
takes over.


Any ideas why this would happpen?

Thanks,
Paul

Reply
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
External link lag dstampor Excel Worksheet Functions 0 July 1st 09 08:30 PM
link issue Pammy Excel Discussion (Misc queries) 1 January 23rd 09 05:40 PM
External app with switches in link Scott Links and Linking in Excel 1 April 3rd 07 11:11 AM
Import External Data -- Fill down formulas Issue Jonathan Excel Worksheet Functions 0 July 12th 06 04:17 PM
External link KIS Excel Worksheet Functions 1 May 28th 05 12:36 PM


All times are GMT +1. The time now is 04:54 AM.

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

About Us

"It's about Microsoft Excel"