Don't Update Links

[EMoe]

Hello Again Programmers,

I am building a report. In that report I have copied some graphs from one workbook into another.

How do I turn off the links updating message for that particular workbook whenever it is opened, besides going into that workbook and inserting a code. I would rather have it encoded from the original workbbok that creates the new workbook.

I know that this happens because the information for the graphs are in another workbook. So I need to copy those graphs to another workbook, turning off the links.


Thanks,
EMoe

[Tim Williams]

If you don't need the graphs to update then you could try just copying
them as pictures (hold down shift and you should get an "edit >> copy
as picture" option).

Tim


"EMoe" <[email protected]> wrote in
message news:[email protected]...
>
> Hello Again Programmers,
>
> I am building a report. In that report I have copied some graphs
> from
> one workbook into another.
>
> How do I turn off the links updating message for that particular
> workbook whenever it is opened, besides going into that workbook and
> inserting a code. I would rather have it encoded from the original
> workbbok that creates the new workbook.
>
> I know that this happens because the information for the graphs are
> in
> another workbook. So I need to copy those graphs to another
> workbook,
> turning off the links.
>
>
> Thanks,
> EMoe
>
>
> --
> EMoe
> ------------------------------------------------------------------------
> EMoe's Profile:
> http://www.excelforum.com/member.php...o&userid=23183
> View this thread:
> http://www.excelforum.com/showthread...hreadid=479014
>

[EMoe]

Hi Tim,

I tried to hold shift over the chart, and I didn't see edit as picture option.

When I said graphs earlier, I meant a charts. Are you talking about the same thing?

EMoe

[EMoe]

Sorry Tim,

Disregard! I see exactly what your talking about. I'll try to see is the macro recorder will give me a code on this function.

Thanks a bunch,
EMoe

[Turbo Turtle]

"EMoe" wrote:
> I am building a report. In that report I have copied some graphs from
> one workbook into another.
>
> How do I turn off the links updating message for that particular
> workbook whenever it is opened, besides going into that workbook and
> inserting a code. I would rather have it encoded from the original
> workbbok that creates the new workbook.
>
> I know that this happens because the information for the graphs are in
> another workbook. So I need to copy those graphs to another workbook,
> turning off the links.

You could do this

Private Sub Workbook_Open()
ActiveWorkbook.UpdateLinks = xlUpdateLinksNever
End Sub

[Turbo Turtle]

"EMoe" wrote:

> I am building a report. In that report I have copied some graphs from
> one workbook into another.
> How do I turn off the links updating message for that particular
> workbook whenever it is opened, besides going into that workbook and
> inserting a code. I would rather have it encoded from the original
> workbbok that creates the new workbook.


You could do this by changing the update links property. as in

ActiveWorkbook.UpdateLinks = xlUpdateLinksNever

[Turbo Turtle]

"EMoe" wrote:

>
> Hello Again Programmers,
>
> I am building a report. In that report I have copied some graphs from
> one workbook into another.
>
> How do I turn off the links updating message for that particular
> workbook whenever it is opened, besides going into that workbook and
> inserting a code. I would rather have it encoded from the original
> workbbok that creates the new workbook.
>
> I know that this happens because the information for the graphs are in
> another workbook. So I need to copy those graphs to another workbook,
> turning off the links.
>

You could do this by changing the update links property. as in

ActiveWorkbook.UpdateLinks = xlUpdateLinksNever

[Tom Ogilvy]

The update links question is asked before any code is executed so using
code/the workbook_open event to change the property is not a solution.

--
Regards,
Tom Ogilvy


"Turbo Turtle" <[email protected]> wrote in message
news:[email protected]...
>
>
> "EMoe" wrote:
> > I am building a report. In that report I have copied some graphs from
> > one workbook into another.
> >
> > How do I turn off the links updating message for that particular
> > workbook whenever it is opened, besides going into that workbook and
> > inserting a code. I would rather have it encoded from the original
> > workbbok that creates the new workbook.
> >
> > I know that this happens because the information for the graphs are in
> > another workbook. So I need to copy those graphs to another workbook,
> > turning off the links.
>
> You could do this
>
> Private Sub Workbook_Open()
> ActiveWorkbook.UpdateLinks = xlUpdateLinksNever
> End Sub

[EMoe]

Yes Tom, you are right. That's why it seems to be my best option is to copy the charts as a picture as previously suggested by another programmer.

Which brings me to another question. Is it possible to create a new workbook from a macro out of another, and in that created workbook insert a code into a module?

Thanks for reply,
EMoe