Linking feature changed in Excel?

Hello,
I am having a problem with linking worksheets. A few weeks ago I would do
this:

1) Open source sheet.
2) Highlight cells. Click EDIT|COPY.
3) Open destination worksheet. CLICK|PASTE SPECIAL

At this point a box would open up called Paste Special box would open that
would allow me to select Microsoft Excel Object and paste a link. This no
longer happens. The window is very different now and does not seem to have
the same functionality. I have tried it in both Excel 2000 and 2003 with the
same outcome. Anyone have any ideas on this?

There's a button on the Paste Special dialog called Paste Link -- is this
what you're looking for?

"bxr222" <[email protected]> wrote in message
news:[email protected]...
> Hello,
> I am having a problem with linking worksheets. A few weeks ago I would do
> this:
>
> 1) Open source sheet.
> 2) Highlight cells. Click EDIT|COPY.
> 3) Open destination worksheet. CLICK|PASTE SPECIAL
>
> At this point a box would open up called Paste Special box would open that
> would allow me to select Microsoft Excel Object and paste a link. This no
> longer happens. The window is very different now and does not seem to have
> the same functionality. I have tried it in both Excel 2000 and 2003 with
the
> same outcome. Anyone have any ideas on this?

Are your worksheets in different workbooks?

If they are, then maybe you've started two different instances of excel (and
opened each workbook in separate instances).

Copy|paste special will show a different dialog if that's the case.

Try opening the first workbook, then file|open the second workbook and see if
things get back to "normal".

Ps.

If you opened the second file by double clicking on it in windows explorer and
want to open that workbook in the same (already running) instance of excel...

Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.



bxr222 wrote:
>
> Hello,
> I am having a problem with linking worksheets. A few weeks ago I would do
> this:
>
> 1) Open source sheet.
> 2) Highlight cells. Click EDIT|COPY.
> 3) Open destination worksheet. CLICK|PASTE SPECIAL
>
> At this point a box would open up called Paste Special box would open that
> would allow me to select Microsoft Excel Object and paste a link. This no
> longer happens. The window is very different now and does not seem to have
> the same functionality. I have tried it in both Excel 2000 and 2003 with the
> same outcome. Anyone have any ideas on this?

--

Dave Peterson

Dave,

You are a genius. Problem solved. I was trying to do it in the same instance
of excel. Thanks for the assist.

"Dave Peterson" wrote:

> Are your worksheets in different workbooks?
>
> If they are, then maybe you've started two different instances of excel (and
> opened each workbook in separate instances).
>
> Copy|paste special will show a different dialog if that's the case.
>
> Try opening the first workbook, then file|open the second workbook and see if
> things get back to "normal".
>
> Ps.
>
> If you opened the second file by double clicking on it in windows explorer and
> want to open that workbook in the same (already running) instance of excel...
>
> Sometimes one of these works:
>
> Tools|Options|General|Ignore other applications (uncheck it)
>
> --- or ---
>
> Close Excel and
> Windows Start Button|Run
> excel /unregserver
> then
> Windows Start Button|Run
> excel /regserver
>
> The /unregserver & /regserver stuff resets the windows registry to excel's
> factory defaults.
>
>
>
> bxr222 wrote:
> >
> > Hello,
> > I am having a problem with linking worksheets. A few weeks ago I would do
> > this:
> >
> > 1) Open source sheet.
> > 2) Highlight cells. Click EDIT|COPY.
> > 3) Open destination worksheet. CLICK|PASTE SPECIAL
> >
> > At this point a box would open up called Paste Special box would open that
> > would allow me to select Microsoft Excel Object and paste a link. This no
> > longer happens. The window is very different now and does not seem to have
> > the same functionality. I have tried it in both Excel 2000 and 2003 with the
> > same outcome. Anyone have any ideas on this?
>
> --
>
> Dave Peterson
>