I am using Excel97 and want to know how to change links to another worksheet
in the same workbook? For example, I have worksheet OTB DEC and OTB JAN in
workbook OTB1. In a separate workbook, I have linked the values from
worksheet OTB DEC in column A. In column B I need the same exact cells
linked, but from the the worksheet OTB JAN. How can I do this without having
to either relink column B or type over "OTB DEC" with "OTB JAN" in every
cell? I cannot use change source because they are both from the same
workbook, OTB1.

Try this sequence with col B selected:
1. Edit Replace "=" with say "zzzz" (convert formulas to textstrings)
2. Edit Replace "OTB DEC" with "OTB JAN"
3. Edit Replace "zzzz" with "=" (re-instate textstrings to formulas)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"amy" wrote:
I am using Excel97 and want to know how to change links to another worksheet
in the same workbook? For example, I have worksheet OTB DEC and OTB JAN in
workbook OTB1. In a separate workbook, I have linked the values from
worksheet OTB DEC in column A. In column B I need the same exact cells
linked, but from the the worksheet OTB JAN. How can I do this without having
to either relink column B or type over "OTB DEC" with "OTB JAN" in every
cell? I cannot use change source because they are both from the same
workbook, OTB1.

I bet that steps 1 and 3 aren't necessary.

Just changing the worksheet name (don't make a typo though!) would work fine.

Max wrote:

Try this sequence with col B selected:
1. Edit Replace "=" with say "zzzz" (convert formulas to textstrings)
2. Edit Replace "OTB DEC" with "OTB JAN"
3. Edit Replace "zzzz" with "=" (re-instate textstrings to formulas)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"amy" wrote:
I am using Excel97 and want to know how to change links to another worksheet
in the same workbook? For example, I have worksheet OTB DEC and OTB JAN in
workbook OTB1. In a separate workbook, I have linked the values from
worksheet OTB DEC in column A. In column B I need the same exact cells
linked, but from the the worksheet OTB JAN. How can I do this without having
to either relink column B or type over "OTB DEC" with "OTB JAN" in every
cell? I cannot use change source because they are both from the same
workbook, OTB1.

--

Dave Peterson

Dave
Perhaps my earlier response should have been:

Select col A
Edit Replace "=" with say "zzzz" (convert formulas to textstrings)

Copy n paste col A to col B

Select col B
1. Edit Replace "OTB DEC" with "OTB JAN"
2. Edit Replace "zzzz" with "=" (re-instate textstrings to formulas)

Select col A
Edit Replace "zzzz" with "=" (re-instate textstrings to formulas)

since OP indicated that
.. In column B I need the same exact cells linked,
but from the the worksheet OTB JAN.
which hints that she wants to populate col B using col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Peterson" wrote in message
...
I bet that steps 1 and 3 aren't necessary.

Just changing the worksheet name (don't make a typo though!) would work
fine.

Ahhhhh.

I should have read the OP's message <bg.

Max wrote:

Dave
Perhaps my earlier response should have been:

Select col A
Edit Replace "=" with say "zzzz" (convert formulas to textstrings)

Copy n paste col A to col B

Select col B
1. Edit Replace "OTB DEC" with "OTB JAN"
2. Edit Replace "zzzz" with "=" (re-instate textstrings to formulas)

Select col A
Edit Replace "zzzz" with "=" (re-instate textstrings to formulas)

since OP indicated that
.. In column B I need the same exact cells linked,
but from the the worksheet OTB JAN.
which hints that she wants to populate col B using col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Peterson" wrote in message
...
I bet that steps 1 and 3 aren't necessary.

Just changing the worksheet name (don't make a typo though!) would work
fine.

--

Dave Peterson