Link worksheets

S

Sandy

I have a workbook (weekly financial workbooks) that contains worksheets that
have links to another workbook. They are in different directories.
When the workbook is finished I save it. When I open it again I get asked it
I want to update the links...I say no...I then open another workbook and say
no also it its links but it changes the links on the 1st workbook that I
opened...What I would like to be able to do is open previous weeks workbooks
say no to the link and have the data the way it way when I did that week..any
help on this matter would be greatly appreciated. --
Stellier
 
M

macropod

Hi Sandy,

In all likelihood, the two workbooks you're opening are linked. Short of
setting recalculation to manual, you can't stop the links updating when the
linked workbooks are both open at the same time.

Cheers
 
S

Sandy

Thanks for getting back...but that doesn't help me...apparently this was not
the case in the past. When you updated the one workbook with the financial
information for week 1 and save it you could reopen it weeks later and the
data that is linked from another workbook would not changed. What we would
like to be able to do is open up 4 weeks worth of financial data and tile
them and then make comparisons. We cannot because whatever was the last week
opened that is the information that is showing in the other 3 weeks in the
linked data fields even though we say not to updating the link information. I
hope this explains the problem better. Thanks in advance for you help and
time in this matter.
 
M

macropod

Hi Sandy,

AFAIK it's been that way since at least the days of Excel v.5 - in the mid
1990s.

Cheers
 
Top