LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 27
Default links to a second workbook doesn't work if origin not open

I have some links from one workbook to another, but when I open only the
destination workbook the link shows #value! error. If I then open the origin,
the link does show the proper value. If I close the origin, the link keeps
the values in destination just during that "session" if I close the workbook
and open again I will need to open the origin as well. Why the link doesn't
keep the values as it should?
 
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
Links work in one workbook, not in another Clayman Excel Discussion (Misc queries) 6 June 26th 07 01:20 PM
My links to another workbook don't work Tony M Excel Discussion (Misc queries) 2 May 16th 06 04:57 PM
links within excel don't work when workbook is e-mailed - why ? E. Nufizinuf Excel Discussion (Misc queries) 1 December 13th 05 04:00 AM
Links only update when external workbook is open CMB Excel Worksheet Functions 6 November 8th 05 12:39 AM
inter workbook links do not update even when both are open ??? Lawrenph Excel Discussion (Misc queries) 3 June 3rd 05 02:14 PM


All times are GMT +1. The time now is 04:41 PM.

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"