Hi, Michelle,

since my Excel is not in english, my description will be a little
approximated...

In the menu bar , go to "Edit" "Links..." (? - second last option)
"Initialization prompt" (? - bottom left button) and select the second
option, which will be more or less like "Don't display alert and don't
update links".

Hope it helps...

Regards!

"Michelle B"
We have pivot table reports that are automatically created by an interface
from another system. The pivot tables and the data are in seperate
workbooks.
When the reports are e-mailed a message box pops up stating that the
workbook
contains links that cannot be updated, if "continue" is selected, we get
the
message that the source data could not be opened. However the pivot table
then opens successfully.
How can we avoid getting these promts when these reports are sent out by
e-mail - we do need the recipient to still be able to use the pivot
function
to 'drill down' to the data.