software

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

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.

Cheersquot;Sandyquot; gt; wrote in message
...
gt; I have a workbook (weekly financial workbooks) that contains worksheets
that
gt; have links to another workbook. They are in different directories.
gt; When the workbook is finished I save it. When I open it again I get asked
it
gt; I want to update the links...I say no...I then open another workbook and
say
gt; no also it its links but it changes the links on the 1st workbook that I
gt; opened...What I would like to be able to do is open previous weeks
workbooks
gt; say no to the link and have the data the way it way when I did that
week..any
gt; help on this matter would be greatly appreciated. --
gt; Stellier
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.
--
Stellierquot;macropodquot; wrote:

gt; Hi Sandy,
gt;
gt; In all likelihood, the two workbooks you're opening are linked. Short of
gt; setting recalculation to manual, you can't stop the links updating when the
gt; linked workbooks are both open at the same time.
gt;
gt; Cheers
gt;
gt;
gt; quot;Sandyquot; gt; wrote in message
gt; ...
gt; gt; I have a workbook (weekly financial workbooks) that contains worksheets
gt; that
gt; gt; have links to another workbook. They are in different directories.
gt; gt; When the workbook is finished I save it. When I open it again I get asked
gt; it
gt; gt; I want to update the links...I say no...I then open another workbook and
gt; say
gt; gt; no also it its links but it changes the links on the 1st workbook that I
gt; gt; opened...What I would like to be able to do is open previous weeks
gt; workbooks
gt; gt; say no to the link and have the data the way it way when I did that
gt; week..any
gt; gt; help on this matter would be greatly appreciated. --
gt; gt; Stellier
gt;
gt;
gt;

Hi Sandy,

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

Cheersquot;Sandyquot; gt; wrote in message
...
gt; Thanks for getting back...but that doesn't help me...apparently this was
not
gt; the case in the past. When you updated the one workbook with the financial
gt; information for week 1 and save it you could reopen it weeks later and the
gt; data that is linked from another workbook would not changed. What we would
gt; like to be able to do is open up 4 weeks worth of financial data and tile
gt; them and then make comparisons. We cannot because whatever was the last
week
gt; opened that is the information that is showing in the other 3 weeks in the
gt; linked data fields even though we say not to updating the link
information. I
gt; hope this explains the problem better. Thanks in advance for you help and
gt; time in this matter.
gt; --
gt; Stellier
gt;
gt;
gt; quot;macropodquot; wrote:
gt;
gt; gt; Hi Sandy,
gt; gt;
gt; gt; In all likelihood, the two workbooks you're opening are linked. Short of
gt; gt; setting recalculation to manual, you can't stop the links updating when
the
gt; gt; linked workbooks are both open at the same time.
gt; gt;
gt; gt; Cheers
gt; gt;
gt; gt;
gt; gt; quot;Sandyquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I have a workbook (weekly financial workbooks) that contains
worksheets
gt; gt; that
gt; gt; gt; have links to another workbook. They are in different directories.
gt; gt; gt; When the workbook is finished I save it. When I open it again I get
asked
gt; gt; it
gt; gt; gt; I want to update the links...I say no...I then open another workbook
and
gt; gt; say
gt; gt; gt; no also it its links but it changes the links on the 1st workbook that
I
gt; gt; gt; opened...What I would like to be able to do is open previous weeks
gt; gt; workbooks
gt; gt; gt; say no to the link and have the data the way it way when I did that
gt; gt; week..any
gt; gt; gt; help on this matter would be greatly appreciated. --
gt; gt; gt; Stellier
gt; gt;
gt; gt;
gt; gt;