software

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.

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

Hope this helps,
Miguel.

quot;Rick Bquot; wrote:

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

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

quot;Miguel Zapicoquot; wrote:

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

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

Miguel.

quot;Rick Bquot; wrote:

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