Referencing Other Workbooks

[Rick B]

I would like to email a workbook with formulas that refer to cells in other
workbooks/worksheets. How can the recipient open the emailed workbook
without being prompted to update it, but still show the most current values
that were pulled from the other spreadsheets? Thank you.

[Miguel Zapico]

You can control the behaviour of the startup prompt in the menu Edit ->
Links. It looks like the option that will fit your need is "Don't display
the alert and don't update automatic links"

Hope this helps,
Miguel.

"Rick B" wrote:

> I would like to email a workbook with formulas that refer to cells in other
> workbooks/worksheets. How can the recipient open the emailed workbook
> without being prompted to update it, but still show the most current values
> that were pulled from the other spreadsheets? Thank you.

[Rick B]

I am using Excel 2000 and I don't see that option under Edit -> Links.
Please help. Thank you.

"Miguel Zapico" wrote:

> You can control the behaviour of the startup prompt in the menu Edit ->
> Links. It looks like the option that will fit your need is "Don't display
> the alert and don't update automatic links"
>
> Hope this helps,
> Miguel.
>
> "Rick B" wrote:
>
> > I would like to email a workbook with formulas that refer to cells in other
> > workbooks/worksheets. How can the recipient open the emailed workbook
> > without being prompted to update it, but still show the most current values
> > that were pulled from the other spreadsheets? Thank you.

[Miguel Zapico]

Sorry, I don't have Excel 2000 available, and I don't know how that option is
managed there.

Miguel.

"Rick B" wrote:

> I am using Excel 2000 and I don't see that option under Edit -> Links.
> Please help. Thank you.
>
> "Miguel Zapico" wrote:
>
> > You can control the behaviour of the startup prompt in the menu Edit ->
> > Links. It looks like the option that will fit your need is "Don't display
> > the alert and don't update automatic links"
> >
> > Hope this helps,
> > Miguel.
> >
> > "Rick B" wrote:
> >
> > > I would like to email a workbook with formulas that refer to cells in other
> > > workbooks/worksheets. How can the recipient open the emailed workbook
> > > without being prompted to update it, but still show the most current values
> > > that were pulled from the other spreadsheets? Thank you.