View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Linked sheets not updating properly with dual monitors

Hi,

Suppose that you are opening a different instance of Excel in each window,
the link from one open workbook is not to the other open workbook, but to the
saved copy. If you make a change in one instance of Excel you will need to
click Save, then switch to the other copy and update links.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"PrattBratt" wrote:

I'm set up with a dual monitor system. With one spreadsheet open on one
monitor and another on the second monitor the linking functions do not
operate. I also can't create new links between the two. Everything works
fine if I have both open in the same screenwith split view. How do I, or can
I, correct for this??